Forum Discussion

tlo11's avatar
tlo11
Frequent Visitor
5 years ago
Solved

Percentage Based Stacked Column Chart

Dear all,

I am having a problem which likely requires some DAX that currently drives me nuts as I do think this should be solvable quite easy. See the attached screenshot of a stacked column chart. What I would like to show is instead of total data lables, a percentage value should be shown per stacked element, i.e.:

 

  • First Column
    • 100% (Orange only)
  • Second Column
    • 203 / 261 = 78% Orange
    • 29 / 261 = 11% Dark Blue
    • 29 / 261 = 11% Light Blue

The chart basically shows the state ("status" as legend) and the count this state has been reached (count of "status"). The "status" is just a string / text field.

 

 

Thank you very much in advance!

 

Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi tlo11 ,

     

    Instead of the Stacked Column chart, use the 100% stacked column chart, or do you want to keep the count on the bar chart but just change the labels?

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Hi tlo11 ,

     

    Instead of the Stacked Column chart, use the 100% stacked column chart, or do you want to keep the count on the bar chart but just change the labels?