Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to 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.
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
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.
@Niels_T , For this you have to change the regional setting. Change region to country uses this number format.