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

nickvanmaele's avatar
nickvanmaele
Icon for Advocate II rankAdvocate 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?

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 🙂
  • LinLinB's avatar
    LinLinB
    Icon for Advocate I rankAdvocate I
    3 years ago

    I'm in Australia and Global Settings only has US English.
    Current Settings allowed UK English but it didn't make any difference.
    I'm using MS Edge browser.
    Edge has UK as language (I downgraded Australian 😞 )
    I'm also aware that with Date formats (Relationship page) you need to choose the "unasterixed" date formats as those will default to US formats.
    Crazy how much time you waste trying to get this to reflect correctly.
    If the format is dd/mm/yy then why the heck does it reconfigure ??? What's the point of chosing a format? (sorry that is just a general rant!)
    Thanks for your tips all the same