Change decimal separator only in report, but not in data and data import

[Truthahn195]

Hello everyone,

I am trying to change the decimal separator shown in my report from comma (,) to point (.). But I only want it to change in the report, not in the underlying data, since the data set I import also contains comma (,). When changing my regional settings from German to English, I get a lot of problems with my data and most of my graphs don't work anymore, therefore I only want to change the separator displayed - is there a way to do this? Replacing the comma in the data is not a feasible solution for me, since I also present the percentages of a total sum with a decimal separator, which is done automatically by Power BI and hence I cannot change by simply replacing the comma by point in my data.

I really appreciate your help!

Best regards, Nina

[amitchandak]

@Truthahn195 , This happens using a regional setting. If you are using German setting are you not getting decimal in place of comma

[Truthahn195]

Unfortunately, this does not work. When changing the regional settings, it seems that I also change the decimal separator for import, and then importing my data does not work anymore.

[amitchandak · Accepted solution]

@Truthahn195 , work in power bi with english setting. Change power bi service setting to german and check, it should work( this will for each user and browser)

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

[Truthahn195]

This worked fine, thank you very much! I wasn't aware of the possibility to change the language setting in Power BI Service