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.

v-lionel-msft's avatar
v-lionel-msft
Community Support
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.