Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Spegkas
Frequent Visitor

BUG: All date slicers changed format to US(mm/dd/yyyy)

All date slicers changed format to US(mm/dd/yyyy) , while all date fields are set to short date dd/mm/yyyy.
This happens using any regional settings on pc or browser and we noticed it in the last 1,5 week.
Also this happens only on service.
Screenshot_7.pngScreenshot_6.png

2 REPLIES 2
ibarrau
Super User
Super User

Hi. I had a similar issue last year. The trick was that the change of the date format needed to be done over Power Query Editor and not in there. I have opened the Transform data menu, click on changing data type regional. In my case, I have picked a Date using locale Argentina (dd/mm/yyyy). Once that was applied and published, the setting changed the date format for the report.

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Thank you for your reply and I guess this might be a valid workaround but its about all the reports of the company that worked just fine until some days ago and it is also about the other formats like decimal separator and separator for thousands that changed, too. So I think it is a universal bug like in this thread:
BUG: Date format has changed to US format in all r... - Page 7 - Microsoft Fabric Community

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.