How to change dot notation to comma

[Niels_T]

Hello,

There is a . that is being used as decimal. I would like to use the , instead.

It seems to only appear in the tables. In my data I've already changed the type and there it does display correctly:

[Syndicate_Admin]

Hello everyone I have a Power Bi panel that consolidates information that many countries in the world load me in an excel by country, power bi consolidates them and I graph them however in some countries they use the comma as a decimal separator and in others the point I have already tried to change comma by point in the database and it gives me an error that I can do because when someone writes the number With comma Power BI converts it to integer

Thank you

[v-lionel-msft · Accepted solution]

Hi @Niels_T ,

My Power BI Desktop version: 2.90.782.0 64-bit (February 2021)

My data source: Local excel file

My test steps：

Step1, Change my computer system setting: Control Panel\Region\Additional settings\Decimal symbol

Step2, Restart and refresh my .pbix file in Power BI Desktop.

My test result(You can see that I successfully changed the delimiter.).

But the methods provided by other blogs are not the same as mine, you can refer to it.

schoennie: Thousand Separator and Decimal Separator in Power BI Desktop, Chrome, IE & Edge

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Niels_T , For this you have to change the regional setting. Change region to country uses this number format.