Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ALEKSGOD
Helper I
Helper I

Comma instead of dot in decimal numbers

Hi,
I would like to replace dot to comma for numbers. 
In power query and data view commas are decimal seperator 8.476,11 (correct)
But in Report view in table same number looks like this 8,476.11 (incorrect)
I already changed regional setting and also settings on my PC. Nothing works...
Any idea chow to change it?

Thanks, 
Aleks

4 REPLIES 4
Bhu1singh
Frequent Visitor

Hi,

 

Try using Tabular editor to change the format of the column.

checkout below link for more details.

https://community.powerbi.com/t5/Desktop/Format-string-in-Tabular-Editor-in-Thousands/td-p/1431643

 

Thanks

Bhuvan

MAwwad
Super User
Super User

Hello,

 

 

Try the SUBSTITUTE Function and replace the "." with "," or vise versa.

 

 

Best

negi007
Community Champion
Community Champion

@ALEKSGOD change the data type to text as it is not a number format.




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

look like it works but when i change to text other visualizations collaps... 
Any other solution?
BTW what do you mean it's not a number format?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.