Number Formatting in Power BI desktop

[divyanshug15]

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. 

[v-hashadapu]

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]

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]

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]

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 · Accepted solution]

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]

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.

[danextian]

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

[v-hashadapu]

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.

[danextian]

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

[v-hashadapu]

Hi @danextian , edited it out. thanks.

[dharmendars007]

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 

[divyanshug15]

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]

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.

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

Remove the currency symbol if not needed.