Forum Discussion
Comma Separator issue
The issue you're facing is related to how the comma separator is interpreted by Power BI Desktop and Power BI Service. In some countries, a comma is used as a decimal separator while in others it is used as a thousands separator. The default format of numbers in Power BI is determined by the regional settings of your local system, and it seems that the format of the numbers in your Power BI Desktop report is set to use a comma as a thousands separator, while the Power BI Service is interpreting it as a decimal separator.
To resolve this issue, you can change the format of the numbers in your Power BI Desktop report to use a period (.) as a decimal separator instead of a comma. You can do this by selecting the field in the report, and then going to the "Modeling" tab in the ribbon and selecting "Format". From there, you can choose the appropriate format for your numbers, and make sure that it uses a period as a decimal separator.
Additionally, you can specify the format of numbers in the DAX measure that you're using. To do this, you can use the "Format()" DAX function to format the numbers in the way you want. For example, you can use the following formula to format the numbers with a period as a decimal separator:
Format(<Measure>, "#,##0.00")
This should ensure that the numbers are displayed consistently in Power BI Desktop and Power BI Service, and resolve the issue you're facing.
- Ishankpruthi3 years agoFrequent Visitor
Hi MAwwad
Thank you for the time. I have also attempted the method, but nothing changed.
- huzaifaakhtar2 years agoNew Member
Hi Ishankpruthi
Did you find any solution?