Forum Discussion

Icon for Helper II rank

Helper II

9 years ago

Solved

date format in slicer

Hi Folks, I am using Slicer for Date and it is displaying in mm/dd/yyyy , Even though i change in formatting ,still in display it is showing as month as first , Anyone have any idea, ...

v-qiuyu-msft
9 years ago
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

Icon for Helper II rank

Helper II

9 years ago

Hi Qiuyun Yu,

Thanks ,It worked in Desktop,But Still in Services it is with mm/dd format.

Icon for Community Support rank

Community Support

9 years ago

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

Adaxer
New Member
8 years ago
Hi i have similar problem in relative date slicer. In my region setting week stat from monday but in P BI slicer it start fromd sunday. How can i change it ??
Anonymous
Not applicable
7 years ago
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.
- wesamko
  Helper I
  7 years ago
  Hi,
  No alternative solution for IE and Chrome so far.
  Regards,
  Wesam
- d_gosbell
  Super User
  7 years ago
  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
  
  see http://geekswithblogs.net/darrengosbell/archive/2019/03/01/fixing-incorrect-date-formats-in-power-bi-report-server-when.aspx
  - nickvanmaele
    Advocate II
    6 years ago
    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?