How to show labels and totals in billions and values in callout in original format on a bar chart?

[darkmetrics]

Good afternoon!

I have a clustered bar chart (you can see it on the screenshot attached to this question). X-axis is dates.

I want to show total values in bars in billions, but keep initial values without any transformations and show initial values without any transformations (not in billions) on the data callouts. For instance, you can see value 54 on the bar chart in red square. It's a value in billions, but i want to show it as 54 (in billions) on the bar chart whereas displaying it as 53942123456 on the data callout (you can see, that on the callout it's also is in billions now as "53.94"). How can I do that? I would like to change formatting, not create new columns in the initial data, if it is possible.

[v-henryk-mstf · Accepted solution]

Hi @darkmetrics ,

Try to change display units from auto to none.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[darkmetrics]

Good afternoon! On your chart numbers on the bars are displayed without any transformations, but I want to show numbers on the bars in millions (but without letter M") and numbers in the data callouts "as is" (not in millions but in original format).

[amitchandak]

@darkmetrics , Check if this approach can help

Custom label
https://www.youtube.com/watch?v=IH4bcHhxunw

[darkmetrics]

@amitchandak I have checked my Power BI Desktop and Power BI Report Server. I can not see "Custom" option for label formatting. I do not like the  "Millions" option because I don't want to see letters in labels.

[darkmetrics]

Thank you, I will check.