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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Mr_Mr
Frequent Visitor

Slicer Dates in Report (Online) showing wrong format

Im on Windows 11 and whilst viewing a report online noticed the date formats in the slicer are mm/dd/yyyy instead of dd/mm/yyyy. Can anyone please advise how to resolve this as other users are seeing the correct version.

Thanks.

2 REPLIES 2
MAwwad
Super User
Super User

The date format in the slicer may be different from the one you are expecting if the report was created on a different computer with different regional settings. To resolve this issue, you can try changing the regional settings on your computer to match the ones used when the report was created.

To do this, go to the "Settings" app on your Windows 11 computer, then click on "Time & Language" and select "Region & Language". Change the "Format" to match the format used in the report (dd/mm/yyyy) and click "OK" to save the changes.

Another solution would be to change the date format directly in the slicer. To do this, go to the report in Power BI, click on the slicer, then in the "Visualizations" pane click on "Format" and then "Format" again. Change the "Type" from "Auto" to "Custom" and enter "dd/MM/yyyy" in the "Custom" field.

Also, check the data source, if the date format is correct or not. If the date format is incorrect in the data source, then it will be reflected in the slicer.

It's also possible that the issue is caused by browser settings, try using different browser and check if the issue is resolved or not.

Mr_Mr
Frequent Visitor

Thanks for the response, I will check with the IT dept in case its the settings as not able to change them without admin authority.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors