Forum Discussion

Helper III

7 years ago

Solved

Stacked Bar Chart - Percent AND Count

Hello World

I'm hoping someone could help. I'm trying to add a count with this stacked bar chart. Here's my visual.

Any help would be much appreciated.

Kind regards

Ray

d_gosbell
7 years ago
I don't think this is possible out of the box, but if you have just the one horizontal bar you could try the following hack.

Create a second chart that is a normal stacked bar
turn on data labels and set the colour to black
turn off everything else on this chart (x-axis, y-axis, legend, headers, etc)
set all of the series to use white as the data color
then size this chart to match the size of the percentage stacked bar
send this new chart to the back and position it just a little higher than the original chart

4 Replies

v-cherch-msft
Microsoft Employee
7 years ago
Hi rayinOz

You may add a measure to count it and drag the measure to tooltips.For example:

Count = COUNT(Table1[Status])

Regards,

Cherie
- rayinOz
  Helper III
  7 years ago
  Is there a way to get it to show in the graph? The reason is that I take a screenshot of the graph and put it in powerpoint, so I would like both a percentage and a count to be displayed.
  
  Possible?
  
  Rayinoz
  - d_gosbell
    Super User
    7 years ago
    I don't think this is possible out of the box, but if you have just the one horizontal bar you could try the following hack.
    
    Create a second chart that is a normal stacked bar
    turn on data labels and set the colour to black
    turn off everything else on this chart (x-axis, y-axis, legend, headers, etc)
    set all of the series to use white as the data color
    then size this chart to match the size of the percentage stacked bar
    send this new chart to the back and position it just a little higher than the original chart