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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
visheshvsh
Regular Visitor

Need to make comma as decimal separator and dot as thousands separator.

I have created my power bi report in Direct Query mode. I have three tables as visuals in the report. In those tables I have decimal values also. But I am not able to show the decimal seperator as comma. I have made modifications in the Options and settings part of Power BI and made them same like my system settings. Still not able to see the report in the required format. Need help here.6.PNG5.PNG1.PNG4.PNG3.PNG2.PNG

3 REPLIES 3
vanessafvg
Super User
Super User

sorry if this is a silly question but have you tried to format the values 

from the ribbon ?

vanessafvg_1-1707290409914.png

 

are these measures?

 

you can also try

 

formatmeasure =
FORMAT ( SUM ( 'table'[value] ), "#,##0.00" )

 

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Thank you for your time.

answering to your question, first formating I have already done. but there the comma act as thousands separator. I need the comma as decimal seperator and dot as thousand separator.

 

I need the values of all the columns that I have shown in the attachment should reflect the same.

ah understood, and you can achieve this in other software on your machine?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.