Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

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

 

 

Need Help

3 Replies

  • Kishore_KVN's avatar
    Kishore_KVN
    Icon for Solution Sage rankSolution Sage
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      Actually I need the format as mentioned below:

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