Forum Discussion

urpalani's avatar
urpalani
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,  ...
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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I remain annoyed that this date format cannot be changed in the slicer's formatting options. Many years before Power BI was even a thing, my company standardized on ISO date format (YYYY-MM-DD) for all reporting to resolve misinterpretations across our international business. Now, I create Power BI reports that are embedded in a corporate web application and am constantly asked why the slicers have the "wrong" date format. Report designers need to be able to control this sort of thing regardless of the user's regional localization settings at the OS or browser level.