Number format change in a report published to PBI service

[mayankdse]

Hi - I have published a report in the PBI service where the columns with numeric values are separated by thousand separators. How can I change that to be separated by a million separator?

Thanks in advance for your responses.

[V-lianl-msft]

Hi @mayankdse ,

You need to change the data format in desktop and republish the report to replace the old report.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mayankdse · Accepted solution]

Thanlks Liang for your reply. I had already done the data format change and the region change in my deskptop. I figured out that when we publish to PBI service we need to update "Language" under settings to "English" rather than default and then it worked fine.