Comma Separator (from lakhs to million pattern)

[Anonymous]

Hi All,

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.

[v-haibl-msft · Accepted solution]

@Anonymous

You need to change format in Control Panel as following screenshot. Then reopen the PBIX file.

Best Regards,
Herbert

[v-haibl-msft · Accepted solution]

@Anonymous

You need to change format in Control Panel as following screenshot. Then reopen the PBIX file.

Best Regards,
Herbert

[Jayadev]

I tried this, does not work for me.

[yachanagupta]

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

)

[rohithmp]

This patterns works for large digits like
Pattern - "##\,##\,##0.00"
Output - 49,82,734.00

But if the value is 0, it returns
Pattern - "##\,##\,##0.00"
Output - ,,0.00

Why is the ',' printing ! How can i avoid that?

[Anonymous]

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

[Anonymous]

Hi Herbert,

Just now tried your solution and it's working perfect!!! 🙂 🙂

Many Thanks!!!!! 🙂 🙂

Sru.

[v-haibl-msft · Accepted solution]

@Anonymous

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

[Anonymous]

Done Herbert!! 🙂

[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