Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Thousand-Separator-and-Decimal-Separator

I have a report with numbers separated by commas when it's thousands.

and I have decimal numbers or percentages separated by points

but when I publish on the web these digits change, that is, the thousand separator is a point and the decimal separator is a comma.

 

On the Desktop Separator for commaOn the Web Separator for point

Custom Visuals
Dashboards
Reports
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    7 years ago

    Hi Anonymous ,

     

    Please go to Power BI service check which settings you are using: 

     

    1. In the Power BI service, select the Settings icon Settings icon > Settings.
    2. On the General tab > Language.

    For example, if you choose Turkish - Türkçe, the thousands separator is a dot and decimal separator is a comma. 

     

    You can set language to English, then you will get your expected result as in Power BI desktop. 

     

    Reference: 

    https://docs.microsoft.com/en-us/power-bi/supported-languages-countries-regions

     

    Best Regards,
    Qiuyun Yu 

     

1 Reply

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous ,

     

    Please go to Power BI service check which settings you are using: 

     

    1. In the Power BI service, select the Settings icon Settings icon > Settings.
    2. On the General tab > Language.

    For example, if you choose Turkish - Türkçe, the thousands separator is a dot and decimal separator is a comma. 

     

    You can set language to English, then you will get your expected result as in Power BI desktop. 

     

    Reference: 

    https://docs.microsoft.com/en-us/power-bi/supported-languages-countries-regions

     

    Best Regards,
    Qiuyun Yu