Forum Discussion

heikomf's avatar
heikomf
Regular Visitor
4 years ago

Format string measures derrived from numbers based on local user settings

Hi all,   I have a question regarding localization of Power BI report formats.   My goal is to use browser settings specific formatting for the users. For instance the numbers are formatted based...
Need Help
heikomf's avatar
heikomf
Regular Visitor
4 years ago

Thanks othy_bi for your answer.

 

That would be one solution, yes. However lets assume I need to use (string) concatenation for some values/visuals. What kind of function would I use to achieve the localized formating? 

 

I saw there is a function USERCULTURE() which can be used to find out the language settings of the user. However my FORMAT() function only accepts two parameters, the optional locale parameter mentioned here  (https://docs.microsoft.com/en-us/dax/format-function-dax) is not supported it seems. Does someone know why is that?

 

What are my other options? 

 

Thanks and best regards

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, heikomf 

    I did not find more information about the USERCULTURE() function in the official document. I can't call this function in measure, how is it used?

    I agree with DataVitalizer  and I think that currently the locale cannot be dynamically identified through Dax function. In the format function, we usually manually enter the third locale parameter ("en-us", "de-De"...) to convert the string.

     

    Best Regards,
    Community Support Team _ Eason