Forum Discussion
divyanshug15
1 year agoFrequent Visitor
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...
- 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
danextian
Super User
1 year agoHi 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.