Format two different data labels in column chart

[Aakex]

Dear all,

I am working to make my chart like this. The one column shows the total number and the another shows the Percentage. One column is related to another. For eg. In first column there is the total number and in another column you can see the 92% which is related to first column. How can I make this in Powr BI?Thanks in Advance.

Sincerely,
Aakesh.

[Anonymous]

Hi @Aakex,

I'll suggest you use a "line and stacked / clustered column chart" instead. I've been where you are before and adding the same value to both column and line (displaying one of them as "Percent of grand total" or creating a measure) worked for me. You'll need to play a bit with the data labels to don't get it messy.

I hope it helps.

[Aakesh]

Thank You! 🙂

[Anonymous]

Hi Aakesh,

If my answer was satisfactory, could you mark it as it? Thank you!