Forum Discussion
comma locale
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.
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 should
To 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 JanC ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution, so other members can easily find it.
Thank you.
