CODEWITHSUNDEEP
excelpowerbidaxdashboard
gregeal
gregeal

Reputation: 69

Staked column chart with multiple categories grouped together in power bi

I am currently struggling to create a stacked column chart with multiple categories grouped together, that looks like stacked and clustered chart all in one chart.

I have done some research but have not gotten any result. I created separate stacked charts as show below, there is no native way to combine them in power bi. enter image description here

What I would like to achieve this chart below, where I have the 3 categories compared side by side for a given year. enter image description here

Could you please help with this?

Thanks

Upvotes: 1

Views: 4749

Answers (2)

gregeal
gregeal

Reputation: 69

Thanks Peter for your response, after some research, I was able to find the below links and tweaked it for my own use case.

https://www.villezekeviking.com/how-to-combine-a-clustered-and-stacked-chart-in-power-bi/

https://www.youtube.com/watch?v=AI3eT1kRje4

Upvotes: 1

Peter
Peter

Reputation: 12375

You can simply use a hierarchy of 2 parameters on the x-axis, Year AND Category, but don't forget to drill down to see them both:

enter image description here

Upvotes: 1

Related Questions