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,

 

 

 

 

 

 

 

 

 

  • 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

34 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support

    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

    • YatinP's avatar
      YatinP
      Frequent Visitor
      Did not work. I have set regional settings to India and not United Kingdon. Is that a problem?
    • YatinP's avatar
      YatinP
      Frequent Visitor
      Did not work. I have set regional settings to India and not United Kingdon. Is that a problem?
    • Ghayyur_abbas's avatar
      Ghayyur_abbas
      Regular Visitor

      Our client organisation have alot of users, we cannot ask each and every user to make changes in their system in order to resolve 1 small issue, please provide us a simple scalable and to the point solution which can be applied from power bi side without involving client.

      • sanjeewauom's avatar
        sanjeewauom
        Frequent Visitor

        Having the same issue. The organization is using "dd/mm/yyyy" and Power BI date slicers are in "mm/dd/yyyy". 

        Cannot ask each and everyone to change their language setting. 

  • siimloitme's avatar
    siimloitme
    Regular Visitor

    I have tried evetything.  

    Changed regional settings. Changed date formats. Changed locale. etc. 

     

    I need my format to be on slicer DD/MM/YYYY  and calendar should start with monday. 

     

    But it ise still MM/DD/YYYY and starts with Sunday. 

    There is no logic.  

    When I changed my date format in power bi the the same formar should be on all the visualizations. 

    In table I have it in correct format but in slicer not.    WTF?

     

     

     

  • Like many others, I cannot get this to work as described. I suspect it is a bug in the  slicer. 

    Besides which, I am using powerautomate to produce a PDF report, which date format will this use? I cannot get powerautomate exported version to display anything other than mm/dd/yyyy which is  a huge problem as these reports as supposed to go to customers.

    Can anybody definitevly solve this problem so that we can fix the date format for a slicer and not have the system attempt to be "helpful" when it is not wanted.

    • Samuel_Tavern's avatar
      Samuel_Tavern
      Frequent Visitor

      The same issue also comes with the Power BI add-in in Power Point, where the slicers are displayed with the American format regardless of what is defined in the design file. This is very annoying.

  • larrytam's avatar
    larrytam
    Frequent Visitor

    Hi all,

     

    I am having the same issue here. Power Bi service forced all the date slicer in all of my report into the US format, 'MM/DD/YYYY'. Should not related to any OS nor broswer setting, all the date slicer was displaying in 'DD/MM/YYYY' format last week. 

     

    Any update ?

     

    Cheers,

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      I have the same issue since this weekend. I want the formats in DD-MM-YYYY

      • larrytam's avatar
        larrytam
        Frequent Visitor

        Hi Anonymous 

         

        It seems like Power Bi fixed the issue overnight. Can you confirm its also been fixed on your end ?

         

        Thanks

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Yep, I see the same thing. What locality are you? I'm English (US). I see the same thing. You change the date format to something like dd/mm/yyyy and in the slicer it shows as mm/dd/yyyy but in other visuals it displays as dd/mm/yyyy (like table)

    • Anonymous's avatar
      Anonymous
      Not applicable

      Greg_Deckler 
         I am still facing issue wherin date in the slicer is changing to mm\dd\yyyy no matter what i do. I have changed system level language to english(UK), brower (chrome & Microsoft edge) language to English (UK), Still no luck. Any other way around for resolving this. Other than date in slicer, all dates in my reports are in dd-mm-yyyy fomrat. Its really annoying and frustrating that i cannot allign the date format of filter to the rest of the dates.

      Regards,

      Hemant

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi Anonymous 

         

        Can you check if you have changed the language and spell check both to English (UK) in the Chrome browser settings?

        After doing this the date in slicers should be formatted as dd-mm-yyyy.

         

        Hope this helps!

         

        Regards,

        Suguna.

  • If you have somehow changed the date format within the slicer itself, and regardless of the date format you change the source data to, it will still not update. It's likely because you have accidentally or unintentionally grouped the dates somehow. This happens automatically in many cases when placing the date field in other pivot sections. 

     

    To revert to the original date format, drag the Date field back into the rows, then right-click and select Ungroup. Now your date should be back in its original format. Now you can insert the slicer, and the date will be in your correct (original) format.