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.
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.