cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Comma Separator (from lakhs to million pattern)

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.
2 ACCEPTED SOLUTIONS
v-haibl-msft
Microsoft
Microsoft

@Anonymous

 

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

 

Comma Separator (from lakhs to million pattern)_1.jpgComma Separator (from lakhs to million pattern)_2.jpg


Best Regards,
Herbert

View solution in original post

@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

View solution in original post

9 REPLIES 9
v-haibl-msft
Microsoft
Microsoft

@Anonymous

 

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

 

Comma Separator (from lakhs to million pattern)_1.jpgComma Separator (from lakhs to million pattern)_2.jpg


Best Regards,
Herbert

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"))
)
Anonymous
Not applicable

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

@Anonymous

 

Does above setting work for your scenario?

 

Best Regards,
Herbert

Anonymous
Not applicable

Hi Herbert,

 

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

 

Many Thanks!!!!! 🙂 🙂

 

Sru.

@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
Not applicable

Done Herbert!! 🙂

v-haibl-msft
Microsoft
Microsoft

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

 

Comma Separator (from lakhs to million pattern)_1.jpg

 

Best Regards,
Herbert

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors