The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
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.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
52 | |
22 | |
12 | |
11 | |
9 |
User | Count |
---|---|
113 | |
31 | |
30 | |
21 | |
19 |