Forum Discussion
Clustered stacked column chart
I'm trying to implement a Clustered stacked column chart. I can't figure out how to do it or find any examples.
The chart would look similar to the image below. Have you got any idea if this can be acieved in Power BI?
trev_likes_PBI
In Power BI Desktop, it’s not possible to create a chart which can combine both Clustered and Stacked column chart together. Because it can’t determine which group of series need to be “clustered”, which group of series need to be “stacked”. And it’s still not supported to add multiple fields into Legend of a chart. The expected result as you posted can’t be achieved. For your requirement, I suggest you add a column to assign type “Forecast” and “Actual”, then build a hierarchy like “Type->Cost”. Put the hierarchy on X-axis, you suppose to drill down the detail level to see those different costs.
Best Regards,
Angelia
36 Replies
trev_likes_PBI
In Power BI Desktop, it’s not possible to create a chart which can combine both Clustered and Stacked column chart together. Because it can’t determine which group of series need to be “clustered”, which group of series need to be “stacked”. And it’s still not supported to add multiple fields into Legend of a chart. The expected result as you posted can’t be achieved. For your requirement, I suggest you add a column to assign type “Forecast” and “Actual”, then build a hierarchy like “Type->Cost”. Put the hierarchy on X-axis, you suppose to drill down the detail level to see those different costs.
Best Regards,
AngeliaThe problem is drill-downs do not work on dashboards, hence the heirarchy cannot be used on dashboards. How difficult is it custom build this visual?
There are paid visuals on appsource now (starting at $7 or so) that can get this done easily
Appsource - Clustered Stacked Column ChartThis link effectively shows the steps of what you mention regarding the column for types and drilldown:
https://www.villezekeviking.com/how-to-combine-a-clustered-and-stacked-chart-in-power-bi/
I've put a solution together in this blog post if it's still interesting after all these years since this thread was posted 🙂
https://www.villezekeviking.com/how-to-combine-a-clustered-and-stacked-chart-in-power-bi/
Brilliant solution! I had a tinker with it for a while. my SQL was already extracting the year as a seperate column as a string, not a Date type. I'm not sure what I did but eventually it just worked somehow and I got a Clustered Stacked graph exactly how I wanted! You're the best!! hanks for sharing the pbix file on your blog as well.
Sorry to reply to an old post, but in case more people are looking for a solution - this tutorial shows how to simulate a clustered stacked chart https://youtu.be/AI3eT1kRje4
trev_likes_PBI I think in power bi using standard stacked column chart you won't be able to split out two columns but it will have different colours for each category of your legend. Something like below.
Thank you ankitpatira. However, a stacked column is not sufficient for what we are trying to implement.
You might want to think about using small multiples, i.e. splitting up the one chart into four small bar charts, one for each country.
If the data isn't too complex small small multiples in general work great to bring out differences among categories.
Hi trev_likes_PBI ,
Here, is a 100 % Stacked Clustered Column Chart where you can put two different values (e.g: Current year sales and Previous year sales) and can easily compare between them based on their category.
100 % Stacked Clustered Column Chart. pbivizedit.com
Download link for the custom visual file on this page,
https://pbivizedit.com/gallery/100stacked-clustered-column-chart
This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,
- anyone, irrespective of technical skills, can create their visuals
- 15 minutes to create a visual from scratch
- opens up many additional attributes to edit (e.g. labels, tooltips, legends position, etc)
Give this a shot and let us know if you face any problems/errors.
You can use the editor to modify your visual further (some modifications cannot be done in the Power BI window and have to be in the editor).Thanks,
Team PBIVizEditI'm trying to use this tool and can't figure out how to add the clustering variable. How do you add a clustering variable?
Hi Riv
Instead of creating with the editor, now there is a direct download option available.
You can directly download the clustered stacked column chart from Appsource. There is a non-certified and a certified version.
https://appsource.microsoft.com/en-US/product/PowerBIVisuals/yavdaanalyticspvtltd1628223732998.clusteredstackedcolumn
https://appsource.microsoft.com/en-us/product/power-bi-visuals/yavdaanalyticspvtltd1628223732998.clusteredstackedcolumnpro?tab=Overview
if you need a modification to the standard one and have to use the editor, then let us know and we can get you help.
Regards,
AsitM
