Decimal separator - point vs comma

[Anonymous]

Hello everybody,

I would like to ask for your help.

My default setting uses decimal comma.

But I need to use decimal point in my report. When I change locale settings of my computer to English, it is not working everywhere.

It works for basic KPIs, ... But I use also measures like this one: avg_stars_gl = "( " & [measure] & " - global )". When I delete the strings, it is OK. But with the strings - it shows decimal comma.

Thank you for your help!

[v-janeyg-msft]

Hi, @Anonymous 

It’s my pleasure to answer for you.

According to your description, I think you can create a measure to calculate the correct result.

Like this:

avg_stars_gl =
"( " & FORMAT ( [measure] , "#,##0" ) & " - global )"

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello @v-janeyg-msft ,

thank you for your reaction. What I am dealing with is the decimal separator, not the thousand separator.

Formatting that would be working for me looks like this "( " & FORMAT([measure],"#,##0.00") & " - global )"

[v-janeyg-msft]

Hi, @Anonymous 

Can you please show me what your data is like?

Best Regards

Janey Guo

[Anonymous]

https://www.uschovna.cz/en/zasilka/EK3LCXXLY5TM6N7N-WPB/ 

@v-janeyg-msft  Here is link to the file with example of my problem.

[v-janeyg-msft · Accepted solution]

Hey, @marie_vitova

You can check these region settings.

then try like this:

Measure = "("&FORMAT(AVERAGE('Table'[Column1]),"General number")&"-gobal )"

Measure = "("&FORMAT(AVERAGE('Table'[Column1]),"#0.00")&"-gobal )"

You may need to restart, or use the data to re-report, I think it will be resolved.

If you do not solve your problem, please feel free to ask me.

Best regards

Janey Guo

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[Anonymous]

@v-janeyg-msft  Thank you! It is working. It is just unfortunate that I have to recreate complete report.

[amitchandak]

@Anonymous , I think you have change regional setting for that.

https://docs.microsoft.com/en-us/power-bi/fundamentals/supported-languages-countries-regions

https://superuser.com/questions/1419853/power-bi-desktop-number-format-shows-american-format-in-visuals-but-european

[Anonymous]

@amitchandak Thank you for your answer.

I have tried to change the regional settings to English (USA) and English (UK) but I still get the same result. The basic KPIs are shown with decimal point (correct) and the composed KPIs as avg_stars_gl ="( " & [measure] & " - global )" are shown with decimal comma (wrong).