Number Formatting in Power BI desktop

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.

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 

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.

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).

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.

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.

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.