Forum Discussion
Helper IIdate format in slicer
Hi urpalani,
The date format display in the slicer visual decided by the local client Regional settings. Please make sure your region setting like below:
Best Regards,
Qiuyun Yu
Community SupportHi urpalani,
When you view the report in Power BI service, the slicer date format s decided by browser language. Take the IE browser as example, you can add English(United Kingdom) language. See: https://answers.microsoft.com/en-us/ie/forum/ie9-windows_7/how-to-change-language-internet-explorer-9/45b941b0-4848-e011-86fd-d485645a8348
Best Regards,
Qiuyun Yu
Hi v-qiuyu-msft
The approach of changing the language to English (United Kingdom) works fine on IE and Firefox, but does not work for Google Chrome.
Is their any alternative for this?
Thanks,
Suguna Menon.
wesamkoHelper I
Hi,
No alternative solution for IE and Chrome so far.
Regards,
Wesam
- d_gosbell
Super User
Anonymous wrote:Hi v-qiuyu-msft
The approach of changing the language to English (United Kingdom) works fine on IE and Firefox, but does not work for Google Chrome.
Chrome has it's own internal regional settings for some reason so you have to change it independant of the OS settings
- nickvanmaele
Advocate II
d_gosbellIn Power BI desktop my date format is not being picked up. Local date format on my Windows 10 = dd/mm/yyyy, but in my Power BI slicer on a Date field, it still is mm/dd/yyyy. Any clues which other setting could be influencing this?
- d_gosbell
nickvanmaele wrote:
d_gosbellIn Power BI desktop my date format is not being picked up. Local date format on my Windows 10 = dd/mm/yyyy, but in my Power BI slicer on a Date field, it still is mm/dd/yyyy. Any clues which other setting could be influencing this?
Power BI Desktop should be using the settings defined in the File > Options dialog. Note that there are "Regional Settings" both under "Global" and "Current File" so check both of those. It could be that someone set the file to use a different locale.
