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
The recommended selection works correctly in both Report Editor and Power BI Desktop (and their reports):
This shows date to all viewers according to their settings.
See more from my blog post on Microsoft site: https://community.powerbi.com/t5/Community-Blog-Staging-Private/Localization-in-Power-BI/ba-p/952439
But when you wish to hardcode it to regional settings, then Report Editor works correctly and Power BI Desktop works incorrectly:
As you can see even the Desktop choice doesn't make any sense. 14.03.2001 is dd.mm.yyyy, not dd/mm/yyyy as it says in parenthesis.
Day / month order is changed correctly, but "/" character needs to be changed to "." as my regional settings say.
You can perhaps copy the implementation from Report Builder where this worked correctly the last time I used it (2020).
P.S. Suggestion: make the default date format as *d.m.yyyy instead of the long format it is now. For backward compatibility you would need to make this change as setting.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.