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.
Hi,
I am using FORMAT to return month name in "MMM" format from date NOW(). I want it to return May (English), not Maj (Danish).
I changed the locale settings on the Server running Power BI Desktop (Power BI desktop language is set to UK English as well), but no luck. Excel gets the formatting right, however... Please see attached screen dump (The upper Formula bar is a Report Level Measure in Power BI Desktop, the lower Formula bar is Excel 2013):
I'm puzzled - any suggestions?
Thanks.
Br, Rasmus
Solved! Go to Solution.
Hi @Anonymous
You must be using Power BI (Danish). This won't be a problem if you use English edition. No other changes of settings needed. Try it. I am just on the way back to English.
Best Regards!
Dale
@Anonymous
Hi,
I have tested a lot. The English edition does return English display. But it won't return English if the file is created with non-English edition initially. So please create a new file with the English edition for now. I will update here if I have more information.
Best Regards!
Dale
I wrote an article explaining how to change the culture settings that is inherited from the operating system current culture when you create a Power BI Desktop file and that you cannot change later (in Power BI Desktop UI).
http://www.sqlbi.com/articles/changing-the-culture-of-a-power-bi-desktop-file/
I hope it helps.
Marco Russo - SQLBI
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |