Power BI Report Server fixing incorrect date formats in Chrome browser
We are using Power BI Report server to publish Power BI Reports internally and we use a “sensible†date format of dd/mm/yyyy
However, our end users commented that our date format was “backwards†ie. mm/dd/yyyy
I checked the report in Power BI Desktop and the date format was correctly picking up my local regional settings.
However when opening the same report in Chrome or Firefox the date was using US regional settings (mm/dd/yyyy):
After doing some google/binging I found that Chrome has its own internal regional settings dialog and they both default to using US settings.
If you go into the Settings menu in Chrome and search for “Language†you will find the following, and it’s not just the default display language that matters the order is also important. Moving “English (United Kingdom)†to the top of the list, then deleting cached images and files fixed this issue.
Clicking on the 3 dots to the right of the language gives you an option to move that language to the top.
This, in turn, alters the regional formatting setting javascript file that is sent down to the browser.
Data Analyst / BI Consultant
2 å¹´This goes also for number formatting. If you want your thousands separator to be something other than a comma, you cannot
Teamleader & Development Consultant p? Thelin Data AB
3 å¹´Amazing info! In MS edge, it doesn't matter what language you have on top. The important thing is the display language of the webbrowser.
Senior Data Analyst at Emirates
5 å¹´We experienced this for the first time. For drop-down slicer and list slicer its working fine but relative slicer is getting its date format either from PC control panel ->region settings for PBI desktop version or browser language settings for published version.
This is a known issue that you will find on most deployments of Power BI in the UK. At least this can be fixed in the browser, unlike those surrounding the last refresh time or currency formatting.