Forum Discussion
Comma Separator Formats in Power BI
Hi Guys, I am new to Power BI Community and this is my first question which I ll be asking in the Power BI Community. So Ihave changed the 'Digit Grouping' settings in my control panel so that my comma separators follow Indian System. In excel the format is working correctly. But in Power BI, the comma format is working only in the Data View Mode and not in the visualization. Please help me with my issue.
And for some reason I am not able to uplaod screenshots here.
Hi Anonymous ,
Microsoft reply:
This is by design. Power BI Desktop or Service does not support reading formatting setting from Windows. The only localization setting that we use from Windows is the OS language.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
- amitchandak
Super User
Anonymous , you need to set currency and regional setting
https://audministrator.wordpress.com/2017/10/31/powerbi-number-and-currency-formatting/
https://docs.microsoft.com/en-us/power-bi/supported-languages-countries-regions
amitchandak and Icey Thanks for your response. I have changed the Regional Settings as well as the Digit Grouping settings from control panel but still it is not showing the correct format in the visualization but it is showing in the data view. If there is something else I need to do, please help with it.
Data ViewVisualization
- Icey
Community Support
Hi Anonymous ,
I have submitted this issue internally. I will notify you of any updates.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Icey
Hi Anonymous ,
Can "regional setting" help you solve the problem?
Best Regards,
Icey
- Icey
Hi Anonymous ,
Microsoft reply:
This is by design. Power BI Desktop or Service does not support reading formatting setting from Windows. The only localization setting that we use from Windows is the OS language.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey! Welcome to the Power BI Community 👋
Power BI visuals sometimes override your system settings. To get the Indian comma format (like 1,00,000) in visuals, you’ll need to manually format the fields in the modeling tab or use a custom format string like #,##,##0.
Also, if you're dealing with comma formatting and want an easy way to test or insert commas properly, try our Comma Inserter tool – super handy for quick fixes!
