100% clustered column chart in Power BI?

[Anthea]

Hello, I use the clustered column chart in a lot of my dashboards, but I cannot see one that can be used when the value is a %. For these I'm using the 100% stacked column chart but the clustered would be much better. Can anyone advise how to create a 100% clustered chart? Many thanks

[MFelix]

Hi @Anthea,

You can use the % on any of the charts you have, so if you had the % column to a clustered bar chart it will give you the results you need:

Top chart is categories in legend bottom is categories on axis, however you can also have values on both axis and legends.

Regards,

MFelix

[Anthea]

HI M Felix, thanks for the response.

When I try this using the Clustered column chart it converts my data to a % but so that the totals across the x axis total 100%, rather than each value totalling 100%.

On my attached example the green columns across the months total 100%, however I would want the amount in January to total 100% (between those that are 'yes' and those that are 'no')

This is how it appears when I do the 100% stacked column which is how I would like it to appear as it gives the right percentage values, however the benefit for me of using a clustered chart is that I can then show the values across different years in the legend. Is that possible?

Many thanks

[MFelix · Accepted solution]

Hi @Anthea,

Do you want have Year and month on your X-axis? In this case use the 100% stacked column chart and place both year and month on tyour x-axis you will get an hierarchy that will allow you to have both years and months on the same chart.

If you double click the year it will give you the months for the select year, if youclick on the last arrow it give you the image on the bottom with all years and months.

Read this documentation regarding the hierarchy use, this works for all type of visuals.

Regards.

MFelix 

[Anthea]

Great thank you!