Forum Discussion
Decimal separator - point vs comma
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.
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 )"
Community SupportHi, Anonymous
Can you please show me what your data is like?
Best Regards
Janey Guo
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
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.
v-janeyg-msft Thank you! It is working. It is just unfortunate that I have to recreate complete report.