cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kochsalz23
Frequent Visitor

Locale is incorrect after conversion to string

Hello,

 

I have observed a strange behaviour when trying to display a numeric measure as a string with an associated unit code. My goal is to display the value with its respective unit in a single string measure, basically simply using the measure itself and appending the unit code. However, the formatting ignores any regional settings on the numeric measure and displays the wrong thousands and decimal seperators.

 

Locale.png

(here the correct formatting is used in the right column)

 

I specifically need it to use the German locale for this, but I don't know how to force it. What can I do?

2 REPLIES 2
V-lianl-msft
Community Support
Community Support

When you install Power BI Desktop from the Windows Store, it installs all the languages (currently, 42 languages) and by default shows the language that corresponds to the Windows default language.

When you download Power BI Desktop as a standalone installer, you choose the default language when you run the installer. You can change it at a later date.

You can also choose a locale to be used when importing data for a specific report.

 

Thank you for the reply,

 

I have already tried changing the regional settings, they did not affect this measure's output. I have other measures in my report that require output to be according to German locale settings and they work flawlessly, it is just this particular mid-measure conversion that is not behaving properly.

 

regional.pngregional2.png

 

 

It is also displayed incorrectly when uploaded to the PBI Service.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.