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
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