Forum Discussion

Niels_T's avatar
Niels_T
Post Patron
5 years ago
Solved

How to change dot notation to comma

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 disp...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    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.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

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's avatar
VdeJong
Frequent Visitor
2 years ago

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