Comma Separator Formats in Power BI

[harshb_141195]

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.

[devbyisty]

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!

[Icey · Accepted solution]

Hi @harshb_141195 ,

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.

[Icey]

Hi @harshb_141195 ,

Can "regional setting" help you solve the problem?

Best Regards,

Icey

[amitchandak]

@harshb_141195 , 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

[harshb_141195]

@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]

Hi @harshb_141195 ,

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.

[pkuchhal]

Hi Icey,

I am really struggling with this problem were you able to find any solution.

[harshb_141195]

Thank You so much @Icey , your efforts are much appreciated.