Forum Discussion

shrmehta's avatar
shrmehta
Advocate IV
9 years ago

Comma Separator

Can anyone help me to change comma separator format from lakhs, crores etc to millions, billions etc. in PBI eg 12,34,56,789 to 123,456,789 
Need Help
shrmehta's avatar
shrmehta
Advocate IV
9 years ago

Hi v-micsh-msft

 

Here is the data as it is displayed in my report

I checked both data columns and report view and they both display the same formatting. Doesn't change if I change the Data Type from decimal number to whole number

 

-Shruti Mehta

v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
9 years ago

Hi Shruti,

 

Well this seems to be a little werid.

Hover the mouse cursor at the thousands seperator, would it make any difference regarding the data in table visuals?

By the way, Microsoft Power BI Desktop now have the October update available, download and install to check if this issue would insist:

Power BI Desktop

Regards

 

  • shrmehta's avatar
    shrmehta
    Advocate IV
    9 years ago

    Hi v-micsh-msft

     

    Hovering shows the same format of comma seperator. I updated to October version and the screenshot I shatred was October version.

     

    Regards