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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
divyanshug15
Frequent Visitor

Number Formatting in Power BI desktop

I am facing issue related to formatting the number from Indian System (2,33,456) to US System (233,456).

I have around 60+ measures in which i want to change the format as mentioned above.

Please suggest.

 

Thanks in advance. 

13 REPLIES 13
v-hashadapu
Community Support
Community Support

Hi @divyanshug15 , Hope your issue is solved. If it is, can you please consider marking it 'Accept as Solution', If it is not, please share the details. Thank you.

v-hashadapu
Community Support
Community Support

Hi @divyanshug15 , Just wanted to check if the issue is solved. If it isn't please share the details, for us to work together in solving it. If it is then please consider marking the answer 'Accept as Solution', so others with similar queries may find it easily.
Thank you.

 

v-hashadapu
Community Support
Community Support

Hi @divyanshug15 , Can you please confirm if your issue is solved. if it is, please consider marking it 'Accepted as solution'. If not please share the details.

Bibiano_Geraldo
Super User
Super User

HI @divyanshug15 ,
For each measure:
Go to the measure in the Fields pane.
Right-click on the measure and select Properties.
In the Modeling tab, click on Format under the Properties pane.
Choose the format as Number and select Thousands separator (comma). This will use the standard US system of formatting numbers.

Make sure your Power BI settings (under File > Options and settings > Options > Regional Settings) are set to the US locale for proper comma separation (this ensures the system understands the US number formatting conventions).

Kedar_Pande
Super User
Super User

Go to File > Options > Regional Settings.
Set the Locale to English (United States).
Save and reopen the report to ensure consistent formatting.

 

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

v-hashadapu
Community Support
Community Support

Hi @divyanshug15 ,Thank you for reaching out to Microsoft Fabric Community Forum.


Please consider following below steps:

  1. Load your report where you want to change the number format.
  2. In the ribbon, click on the "Modeling" tab.
  3. Click on "Format" and then select "Custom".
  4. In the "Custom format" box, enter #,##0. This will change the number format to the US system.
  5. If you have multiple measures, you can repeat the above steps for each measure.

Below is an example of how you can create a new calculated column to apply the format:

FormattedValue =

VAR OriginalValue = [YourMeasure]

RETURN FORMAT(OriginalValue, "#,##0")


If this helps, please mark it ‘Accept as Solution’, so others with similar queries may find it more easily. If not, please share the details.

Sorry but how does creating a new calculated column apply the format to all measures at once?










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


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Hi @danextian ,Thank you for reaching out to Microsoft Fabric Community Forum.


I understand the confusion, creating a calculated column won't directly apply formatting to all measures at once. I intended to show how you can apply a format to a specific value, but it won’t globally apply to all measures.

Unfortunately, Power BI doesn’t have a direct way to apply the formatting to all measures in a single operation, but you can simplify the process using one of the methods I mentioned in my earlier reply.

If this helps, please mark it ‘Accept as Solution’, so others with similar queries may find it more easily. If not, please share the details.

this statement is confusing the users: or you can create a new calculated column to apply the format to all measures at once.










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


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Hi @danextian , edited it out. thanks.

dharmendars007
Super User
Super User

Hello @divyanshug15 , 

You can follow the below steps to change Power BI Regional Settings

  1. Go to File > Options and settings > Options.
  2. Under Global > Regional Settings, select English (United States) as the regional format.
  3. Click OK and restart Power BI Desktop.

 

Also you can us the below DAX to format the number to US settings but the it will be in text format.

 

US_Formatted_Measure = FORMAT([YourMeasure], "###,###")

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

 

Thank You

Dharmendar S

LinkedIN 

 

I have tried to change Regional Settings but it is not working for me even i have tried custom formatting in modelling tab. Still did not work. 

danextian
Super User
Super User

Hi @divyanshug15 

 

Relationship/diagram view has an option to select multiple measures at once and apply a format to it. Make sure that measures selected return numbers and not any other data type.

danextian_0-1734499332957.png

For custom formatting following the US' enter:  \$#,0;(\$#,0);\$#,0 or simply $#,#

Remove the currency symbol if not needed.










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


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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