Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Decimal separator - point vs comma

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 Eng...
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    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 )"

    6.png7.png

    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.

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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 )"