Forum Discussion
Number Formatting in Power BI desktop
- 1 year ago
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
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).