I have a dashboard that when publishing to web the format of the date in the slider changes.
Example on desktop:
The date is in "uk' format, DD/MM/YYYY
but when published the same slider shows in USA format when acessing it on the web:
Strangely on both other formats such as list show "uk" format:
The original date is of the format YYYY-MM-DD, ie 2017-01-31 which is "transformed" on input using locale (uk). Modelling setting then used to get the required display format.
Seems strange that on the web, list is UK format, select between/before/after is USA format, any ideas ?
Solved! Go to Solution.
Fixed it!!!! - Well my DBA colleague found the solution.
The reason it was working for some users and not others is the following:
When a user had their default language set to English UK then their language setting in Power BI would remain unset.
When a user had their default language set to English US then their language setting in Power BI would get set to English.
(This is why we had some users working properly)
There appears to have been an update on the Power BI Service recently that allows you to set the language setting to respect the browser settings again.
(This was not the case earlier this year http://community.powerbi.com/t5/Service/Language-Settings-Power-BI-Cannot-set-to-British-English/td-... )
This means, you can now correct your language in your browser and then setting the Power BI Service language to default and the issue should be fixed.
To do this:
Change your browser language to English (UK) (or relevant language).
IE: Set IE Default Language (same for IE 11)
Chrome: Set Chrome Default Language
Then, in the Power BI Service, under Settings > Language, set it to Default (browser language).
Choosing this means the dates in my reports are now in the correct format, DD/MM/YYYY.
Good point, @dkay84_PowerBI
I think in my case(New Zealand) we are hosted in Australia, so the format should still be the way I want it to be.
I reproduce the issue by modify the "Formats" setting at "Region". Based on test, it seems like the date records stored with a fixed format at service side. You can post this scenario to ideas.
In addition, you can also add a calculate column to transfer the date to text format. then use the new column as the date source of the slicer.
Great that you managed to reproduce it, I will definitely add it to ideas.
Could I check what you mean by "Format" setting at "Region" ? so I can detail the issue correctly.
I did try transferring the date to text format but then the silder doesn't provide the between/before/after functionality. As expected I think as it's not a date format and can't see a way to change the format once on the server.
>>Could I check what you mean by "Format" setting at "Region" ? so I can detail the issue correctly.
It means the region panel of system setting.
>>I did try transferring the date to text format but then the silder doesn't provide the between/before/after functionality. As expected I think as it's not a date format and can't see a way to change the format once on the server
Yes, If you transfer date type to text, the date range feature of slicer will be disabled, I also haven't found a solution to solve this issue.
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!