Forum Discussion

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

Anonymous

Not applicable

7 years ago

Hi there shrmehta,

Please try this, works for me

Power BI is picking up Currency format from Local computer where you create you desktop file (.pbix).

So before opening your pbix, go to control panel >Clock lang>Region>Currency and change it as needed.

and change region to USA or CANADA etc.. you should get millions, billions.

Cheers

Van2050