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.
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.