Forum Discussion
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
- AnonymousNot 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-msftCommunity 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- YatinPFrequent VisitorDid not work. I have set regional settings to India and not United Kingdon. Is that a problem?
- YatinPFrequent VisitorDid not work. I have set regional settings to India and not United Kingdon. Is that a problem?
- Ghayyur_abbasRegular 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.
- sanjeewauomFrequent 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.
- siimloitmeRegular 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?
- d_gosbellSuper User
This can also be influenced by settings in the browser. I have a post here on my old blog site https://web.archive.org/web/20200111123636/http://geekswithblogs.net/darrengosbell/archive/2019/03/01.aspx (posting a link via archive.org since the blog hoster appears to be down at the moment - one of the reasons I no longer blog there)
- c_cook28954Advocate II
Thanks for this mate - solved my date issue in Chrome and it seems to be very similar to the issue everyone else in this thread is encountering
- amazingwillNew Member
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_TavernFrequent 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.
- Allen1314Frequent Visitor
it's only works on PowerBI Desktop, but when we check it on "https://app.powerbi.com", it's still show date with "MM/DD/YYYY" format, not "DD/MM/YYYY"
- larrytamFrequent 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,
- AnonymousNot applicable
I have the same issue since this weekend. I want the formats in DD-MM-YYYY
- larrytamFrequent Visitor
Hi Anonymous
It seems like Power Bi fixed the issue overnight. Can you confirm its also been fixed on your end ?
Thanks
- Greg_DecklerCommunity 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)
- AnonymousNot 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
- AnonymousNot 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.
- davinavilleNew Member
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.