Hi,
I am having trouble with the format of the date displayed in the Date slicer of power BI.
The dates in my data are in UK format but the date slicer is displaying them in US fromat.
Attaching screenshot of sample report: DateSlicerDateFormat
Please help.
11 Comments
- v-haibl-msft
Microsoft Employee
Please go to system control pane to change the region format to UK. Then close and reopen the PBIX file to see the result.
Best Regards,
Herbert- m1032499Frequent Visitor
Thanks for this. I was able to change the format in the desktop version, but the published version is still showing the US fromat.
Please help.
- v-haibl-msft
Microsoft Employee
I can repro the same issue as you. I’ve reported it internally to Power BI Team: CRI 41498435
I’ll post here once I get any update about it.Best Regards,
Herbert - Vicky_Song
Impactful Individual
Status changed:NewtoAccepted - v-haibl-msft
Microsoft Employee
I’ve got response from the Product Team.
This is being tracked by a bug internally. But for now that is by design.
Best Regards,
Herbert - Vicky_Song
Impactful Individual
Status changed:AcceptedtoDone - v-haibl-msft
Microsoft Employee
If you want to use the minimal UK date formats, you can set your browser to UK locale as following screenshot.
Best Regards,
Herbert - kdonahue100Frequent Visitor
We're having this same issue. We have hundreds of clients all in Australia using the reports, and I don't want to have to ask them to update their browser settings. Is there any way we can force the visualization to display in the format we have specified? I set the format of the date for the slicer to "d/MM/yyyy", but it still displays in American format for most of our users.
- jeaninnesFrequent Visitor
I'm having the same issue. I'd love to know a resolution to this.
- tannera
Advocate II
This problem is present in Power BI Service. Any fixes in view?
- jeaninnesFrequent Visitor
So I think I found a fix to this, at least if you are using Google Chrome browser. In Google Chrome settings, Advanced, select your language as English (United Kingdom). I have used either English (Australia) or English (United Kingdom) and they both work. Then in Power BI service, go to settings and make sure your language is set to use the browser default.
Doing this, I have been able to get my report slicers display the date correctly for Australia. However - I realise that this does require all users to update their browser settings - which might not be the solution you are after.