Number with Comma separator format shown in Power Bi Desktop is different in Power Bi Service

[Anonymous]

Hello Community,

Need a little help,

 The sum of a numeric column in the Power BI desktop column is shown as 4,71,85,574 but after publishing it to service it becomes 47,185,574.

Could anyone please help to fix this comma separator issue means the service should show the same format as the Desktop.

Power Bi Desktop

Power Bi Service

An early response would be highly appreciated.

Thanks & Regards

Manoj

[Kishore_KVN]

Hello @Anonymous ,

Unfortunately power BI service use brower location settings and change it automatically. What you can do is, you can align Power BI Desktop with Service. 

In Power BI Desktop you can create a measure using format function as shown below:

Comma Format = FORMAT(SUM('Table'[Sales]),"0,#")

This will change the output as below:

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[Anonymous]

Actually I need the format as mentioned below:

4,71,85,574 in the Power Bi web service.

[Tahreem24]

@Anonymous  Check this post

Solved: Desktop Decimal Format Overwritten by Service Loca... - Microsoft Fabric Community