Forum Discussion
Number Formatting in Power BI desktop
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
Community SupportHi divyanshug15 ,Thank you for reaching out to Microsoft Fabric Community Forum.
Please consider following below steps:
- Load your report where you want to change the number format.
- In the ribbon, click on the "Modeling" tab.
- Click on "Format" and then select "Custom".
- In the "Custom format" box, enter #,##0. This will change the number format to the US system.
- 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.
Super UserSorry 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.