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
Icon for Community Support rankCommunity Support
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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