Forum Discussion

Aakex's avatar
Aakex
New Member
8 years ago

Format two different data labels in column chart

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.

 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Aakesh,

         

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