Forum Discussion
Comma Separator (from lakhs to million pattern)
My Data gets displayed in lakhs format.. Can anyone help me out with the method to make it displayed in million format using a comma separator?
Thanks in advance.
Anonymous
You need to change format in Control Panel as following screenshot. Then reopen the PBIX file.
Best Regards,
HerbertAnonymous
You can accept the right answer as solution so that other ones who have the same problem can find the correct solution quickly.
Best Regards,
Herbert
10 Replies
v-haibl-msftMicrosoft Employee
Anonymous
You need to change format in Control Panel as following screenshot. Then reopen the PBIX file.
Best Regards,
Herbert- Jayadev
Helper I
I tried this, does not work for me.
- Measure = IF(SUM([column_name])>=10000000,format(SUM([column_name]),"##\,##\,##\,##0"),if(SUM([column_name])>=100000,format(SUM([column_name]),"##\,##\,##0"),FORMAT(SUM([column_name]),"##,##0")))
- v-haibl-msft
Anonymous
In Power BI, we can define Data Labels Display Units for some visual charts. We can also create a measure/column to change scale. Not sure if you are looking for these two solutions.
Best Regards,
Herbert Thanks Herbert!
However I'm aware of this Data Label option in visuals; I'm facing issue in Table visual.
In my table data is getting displayed in Indian System (Lakhs, Crores...etc - Ex: 10,50,600) however, I want it to get displayed in International system (Hundred Thousand, Million...etc - Ex: 1,050,600).
Kindly help me out with this issue.
Many Thanks.
Sru
- v-haibl-msft
Anonymous
Does above setting work for your scenario?
Best Regards,
Herbert
