Forum Discussion
Clustered stacked column chart
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
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/
Hi Anonymous ,
Interesting solution. Thanks for sharing
Cheers
CheenuSing
Hi, for the same, if multiple values are drilled down in x axis, for each of those parameters, how to show it in 2 stacked and one bar in clustered fashion like this, u have made it for single parameter.... any heads up?
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.
This solution worked wonders for me, thank you! It did turn out the data structure of my source was similar to the one in your solution so it worked like a charm. But for other users out there, keep in mind you may need to tweak your data structure to make this work. Good luck!
This doesn't work for me, I just get identical stacked charts next to each other.
