Data label formatting with international thousand separators in column chart

[Shahid12523]

Hi Everyone,

I have a column chart where my data labels are showing in the Indian numbering system, for example:

45,97,861
1,74,17,445

But I want them to appear in the international format with standard thousand separators, like:

4,597,861
17,417,445

I tried using a DAX measure with FORMAT(SUM(Invoice_CSV[Total Invoiced (excl)]), "#,0"), but since FORMAT returns text, the chart does not allow me to use it directly for the data label.

Is there a way to force column/bar chart data labels to display using international thousand separators, without switching to a table or card visual?

[v-tejrama]

Hi @Shahid12523 ,

Thank you @Royel for the response provided! 

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your understanding!

[v-tejrama]

Hi  @Shahid12523 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you,

Tejaswi.

[v-menakakota]

Hi  @Shahid12523  ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Best Regards, 
Community Support Team  

[v-tejrama]

Hi @Shahid12523 ,

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

Thank you.

[Royel · Accepted solution]

Hi @Shahid12523 here is a quick fix 

1. Select your chart and enable data lebel 

2. Then click format -> General -> Data Format -> Select Your Column or measure  -> Custom 

and set this #,##0 to get your desired results. 

Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!