Staked column chart with multiple categories grouped together

[Anonymous]

I am currently struggling to create a staked 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.

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

Could you please help with this?

Thanks

[Anonymous · Accepted solution]

Thanks  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

[FredNo]

Hi,

I am having the same situation as you and would be very interested if you could share how you adapted the method provided in the link you shared. 

[Ashish_Mathur]

Hi,

Share some data to work with.

[negi007]

@Anonymous  yes this is possible. currently what i see from the above examples that you have seperate columns for each categoryA, B and C. in this case i would suggest you to combine these category in one column using pivot featue in the powerquery. Then you will have one column for Threshold (above or Below) and one column for Cateogry(Catogry A, B, C). this way you will be able to achieve the result.

if you still face issue while floowing above steps, then i would suggest you to share your data in the text format that I can copy in my powerbi file. hope this take you in the right direction