Change separator from period to comma

[KamilRetkiewicz]

Hi guys,

I wanted to ask how to change the display of values from dot to comma on the visualization? The format and substitute function also power query replace value is out of the question because I can't store it as text. I've also inserted “hard” formatting and also nothing. I insert screen and my regional settings below. Thank you in advance.

[Ritaf1983]

Hi @KamilRetkiewicz 

Please refer to the linked answer with step by step guide :

https://community.fabric.microsoft.com/t5/Desktop/How-to-replace-dot-in-decimal-numbers-to-comma-not...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[DataNinja777]

Hi @KamilRetkiewicz 

This issue likely stems from the locale settings. 

1. Go to File > Options and Settings > Options.
2. Under Regional Settings (on the left), change the Model Locale to the desired region that uses commas as decimal separators (e.g., Germany or France).
3. Click OK, and refresh the visuals.

Effect: This change ensures that all numerical values are displayed according to the selected region’s format (e.g., 1.234,56).

Best regards,