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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

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
7 years ago

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
    7 years ago

    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.