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

[VdeJong]

Hello, I have the same problem. 
I still have reports in Excel, where I choose English (Dutch) and I get the right notation. However I get in Power Bi not a correct notation and get were the decimal is a point instead of comma.
Also the date is different instead of dd/mm/yyyy, how we report in Europe, apart of the UK, I get the date as mm/dd/yyyy.

Also when I publish the report, I have to make to transfer the page into a ducth setting so the decimal will be a comma, however if somebody else has a differnt setting, in English the the decimal will be a point again.

In my opinion is this a software issue and should be solved by microsoft. Also here in Europe we need to follow certain standards and norms.

So if there is a solution to fix this issue permanthly then it would be a great help

[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.

[VdeJong]

If you change regional settings then also the words for the month will change. I live in the Netherlands but need to report in English there for the month should be english, however the decimals should be a comma instead of a dot. So in my opinion this is a software issue and should be done there.
In excel I can do it without problem, however in Power Bi it's probably not possible