Double Stacked Column Chart / Combination of Stacked and Column Chart

[andrehawari]

Hi, my client requested to create a chart that combine stacked and column chart together.

From my research, most of the solution only say "You can't"

https://community.powerbi.com/t5/Desktop/Clustered-stacked-column-chart/m-p/144714

also, there are custom visual from 3rd party company, which I can't use due to security reason

http://www.defteam.com/stacked-clustered-bar-chart/

I mean, Are there any workaround to get into that chart, i.,e. manipulating the data so the axis can be adjusted (there are tips in excel to manipulating the axis, but i am not sure how to do it in powerBI) ?

https://peltiertech.com/clustered-stacked-column-bar-charts/

thanks

Andre

[Anonymous]

I have put together this solution that uses measures and is not depending on the data structure to be in just one table if it's still interesting.

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

[jennymae4]

I followed this and my X axis are United States Forecast, United States Actual, United Kingdom Forecast, United Kingdom Actual - even with turning concat off.  I cannot get Country on a seperate line.

[PratikB]

Hi @andrehawari

You can do that in another way, create a hierarchy of Country=>Type and use that value in the x-axis, and use `Type->Cost` as the legend.

I think this would help you to get what you are looking for. 
The below Image will give you more clarity.
you can vote for this idea.

[cwc]

HI Partik ,
i need to remove space beween forecast and actual bars and need space after country grouped bars ,it is possible ?

[Anonymous]

@PratikB  Hi Pratik - Do you happen to have a sample pbix of this that you could share?

[jennymae4]

I followed this but when I drill through I get United States Forecast, United States Actual, United Kingdom Forecast, United Kingdom Actual.  I don't get the Country on a seperate line for X axis; even with turning concat off.

[v-juanli-msft · Accepted solution]

Hi @andrehawari

Currently, It is not possible to create a Combination of Stacked and Column Chart, you can vote for this idea.

A workaround described in the fiist link would like below

Best Regards

Maggie