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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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