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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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
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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors