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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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