comma locale

[geertchampion]

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?

[v-menakakota]

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.

[v-menakakota · Accepted solution]

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.

[geertchampion]

unfortunately no:

it is driving me up the wall, refreh, restart, tried everything, any suggestions?

[v-menakakota]

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.

[v-menakakota]

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.

[v-menakakota]

Hi @geertchampion ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[ray_aramburo]

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.

[geertchampion]

unfortunately no:

it is driving me up the wall, refreh, restart, tried everything, any suggestions?

[ray_aramburo]

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.