Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Trouble with Format function when concatenating a string, locale is not respected

Hi, Im trying to create a text string that concatenates both a numeric value and a decimal value.     I'm using Text measure = FORMAT([Numeric value];"#,0") &" ( "&FORMAT([Decimal value...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Okay I have found some more info regarding this issue.

marcorusso explains in this article ( link ) that the culture of the data model does not change after the file has been created. This apparently has the consequence that functions such as FORMAT only respects the culture that is set for the data model and not what is set in the GUI.

 

I was able to change the culture of my model to "sv-SE" using Marcos steps in the article and it solved my current formatting issue.

 

However, regardless of my culture setting in my OS all new PBI-files that I create seems to get the culture "en-US" so there must be something that is not working as it should!

 

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

Anonymous

 

I’ve got response from the Product Team.

 

The model's culture is en-US so it seems like it is created on an US English machine. DAX functions use locale derived from the culture set in the model, not on the machine which the model is used. Note that once a model is created, its culture cannot be changed.

 

Best Regards,
Herbert

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    v-haibl-msftthanks for the response, I have understood that the functions use the locale from the data model. But as I stated in my last post: regardless of my OS culture (which is set to sv-SE) all my new models still get the culture en-US. I'm using the august version of PBI Desktop with english language but I guess that should not matter?