Forum Discussion

urpalani's avatar
urpalani
Icon for Helper II rankHelper 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,  ...
Need Help
  • v-qiuyu-msft's avatar
    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

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
6 years ago
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.

nickvanmaele's avatar
nickvanmaele
Icon for Advocate II rankAdvocate II
6 years ago
Thanks for replying. Solved the problem Sorry that I did not think of this 🙂