show values with comma instead of decimal

[xreagornx]

I have an excel file that contains data such as 2.0, 4.5, 4.6, etc. I am trying to show the data as 2,0. 4,5. 4,6. I have tried changing the regional location to french(france), germany, but it either doesnt work or makes the data show up as 20 instead. How can I use comma separators instead of decimals?

[Anonymous]

Hi @xreagornx,

Thanks @ryan_mayu, @rohit1991, @danextian  and @rajendraongole1 for Addressing the issue.

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[xreagornx · Accepted solution]

Hello, none of the solutions worked for me but I ended up finding my own solution 

[Anonymous]

Hi @xreagornx,

Can you please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Vinay Pabbu

[Anonymous]

Hi @xreagornx,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[ryan_mayu]

@xreagornx 

you can also try to replace comma in PQ

[rohit1991]

Hi @xreagornx ,
To display numbers with a comma as the decimal separator (e.g., 2,0 instead of 2.0) in Power BI, you need to ensure both your system and Power BI are aligned on regional settings. Simply changing the regional setting within Power BI Desktop may not be enough if the data is being interpreted incorrectly during import. 

First, go to File > Options and settings > Options > Regional Settings in Power BI and set the Locale to a region that uses commas as decimal separators, such as French (France) or German (Germany). Then, re-import your data to ensure it's parsed correctly. If the numbers are still being misread (like 2.0 becoming 20), make sure that in your Excel file, the values are stored as numbers and not as text. Also, check that your Windows regional settings (Control Panel > Region) match the desired format, as Power BI can inherit these. 

Finally, format the field in Power BI by selecting the column and choosing the proper number format under the Modeling tab. This combined approach should correctly display your decimals with commas.

[rajendraongole1]

Hi @xreagornx  - Hope you have changed in below options and settings from file.

File → Options and Settings → Options

Under Regional Settings → Choose French (France) or a locale that uses commas

Reload your model

the above one is one option. 

second should, f you just want to show it as text with a comma:

Formatted Value = SUBSTITUTE(FORMAT([YourNumber], "0.0"), ".", ",")

Hope this helps.

[xreagornx]

I still need the column to be numerical. So what I did was change my locale on my computer in control panel. 

Here https://gyazo.com/c3d0e5dad331152e017555f9364c66f8

My data in power bi looks like right https://gyazo.com/0fe78ea35e5a7232a9ee2fdf4a955d16

But when I bring in data labels for my chart, it still uses decimals. https://gyazo.com/d3f3bb684a095605212d033165107539

[danextian]

Hi @xreagornx,

As @rajendraongole1 mentioned, go to Power BI Desktop options, not control panel.