Forum Discussion
comma locale
i am really getting insane: i am trying to get a comma as a decimal indicator, but nothing works: options -> locale, both regional global and current fiole, format in the measurement etc etc, everytime that .. dot appears. What am i doping wrong? is it enforcerd this way now?
Hi geertchampion ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
I know how frustrating this can be getting Power BI to display commas instead of dots for decimals can feel way harder than it shouldTo fix this, try opening Power Query and changing the column type using a specific locale. Right-click the column you’re working with, then choose "Change Type" "Using Locale". Please go through the screenshot .
In the dialog that pops up, set the data type to "Decimal Number" and choose a locale like German (Germany) these use a comma as the decimal separator.
If it gives you an error or doesn’t seem to apply, try changing the column to text first, then apply the "Change Type using Locale" again. That usually does the trick.
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
9 Replies
Hi geertchampion , let me know if this previous post works. After the Regional Settings configuration you need to "enforce" it within Power Query to pick the locale.
unfortunately no:
it is driving me up the wall, refreh, restart, tried everything, any suggestions?The other solution that personally I don't like is to create a new measure with DAX to customize its format. The negative aspect for that is that you'll only be able to use it as a final outcome, as it will turn numerical values into strings. Check this post as a reference.
Hi geertchampion ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
I know how frustrating this can be getting Power BI to display commas instead of dots for decimals can feel way harder than it shouldTo fix this, try opening Power Query and changing the column type using a specific locale. Right-click the column you’re working with, then choose "Change Type" "Using Locale". Please go through the screenshot .
In the dialog that pops up, set the data type to "Decimal Number" and choose a locale like German (Germany) these use a comma as the decimal separator.
If it gives you an error or doesn’t seem to apply, try changing the column to text first, then apply the "Change Type using Locale" again. That usually does the trick.
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.unfortunately no:
it is driving me up the wall, refreh, restart, tried everything, any suggestions?Hi geertchampion ,
Sometimes, even if the model uses a comma as the decimal separator, Power BI visuals may still display numbers in the US/English format. This is because the visual layer doesn’t always follow the model or import locale settings.
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Hi geertchampion ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
