Stacked Bar Chart - Percent AND Count

[rayinOz]

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

[v-cherch-msft]

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]

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 · Accepted solution]

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

[v-cherch-msft]

Hi @rayinOz 

I would suggest you use Line and clustered column chart.Please check the format for the chart in attachment.

Set the Stroke width to 0: The line would be hidden.

Regards,

Cherie