Forum Discussion
Solved
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 s...
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
dharmendars007
Memorable Member
Memorable MemberHello divyanshug15 ,
You can follow the below steps to change Power BI Regional Settings
- Go to File > Options and settings > Options.
- Under Global > Regional Settings, select English (United States) as the regional format.
- 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
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.
