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.

amitchandak's avatar
amitchandak
Super User
5 years ago

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

  • VdeJong's avatar
    VdeJong
    Frequent Visitor
    2 years ago

    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