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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Solution Sage
Solution Sage

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.