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
v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
9 years ago

Hi shrmehta,

Could you please share the screenshot of the wrong format data in table visuals?

I created mine and it displays well.

By the way, it is also available to change the data type under report View (we need to click on the value column first to make the Modeling available), check if it will have any difference when changing the format or data types.

Regards

ShootingBlanks's avatar
ShootingBlanks
New Member
9 years ago

Hi @Michael_Shao -

 

Sorry to drudge up this old topic, but I can't find that comma icon anywhere!  Here is what my ribbon bar looks like...

 

Any ideas???

  • MarcelBeug's avatar
    MarcelBeug
    Community Champion
    9 years ago

    Your screen shot is from the query editor. The comma icon is on the Modeling tab in data view or report view.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Same issue here , anyone found the answer ? 

       

      Stuck with this : 1,61,350

      Expected output: 161,350

       

      i've tried following

      1. regional settings change
      2. currency change
      3. thousand separate on /off 

      Thank you in advance!

      Vans