Combine Cluster and Stacked Bar Charts

[geauxtigers71]

Below is a sample of my data set.  I am able to create a cluster bar chart with 3 separate bars for each column (# Planned, Actual Completed vs Plan, and Additional Completed).

I would like to make two bars....One with the # Planned and the other with the Actual Completed vs Plan and Additional Completed combined into one bar.  Does anyone know if this is possible? Thank you!

[Ritaf1983 · Accepted solution]

Hi @geauxtigers71 
Please refer to a linked blog post, seems it can help ( note: it has a sample file)
https://www.villezekeviking.com/how-to-combine-a-clustered-and-stacked-chart-in-power-bi/
Or Consider changing it to a combo chart where planned will be a marker line, it is much more reader-friendly:

A sample file for this option: Here 
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Villezekeviking · Accepted solution]

There is a workaround where you use a measure to get this to work out of the box in Power BI Desktop.

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

I've described the solution in here and you can tweak it for your labels.

[Ritaf1983 · Accepted solution]

Hi @geauxtigers71 
Please refer to a linked blog post, seems it can help ( note: it has a sample file)
https://www.villezekeviking.com/how-to-combine-a-clustered-and-stacked-chart-in-power-bi/
Or Consider changing it to a combo chart where planned will be a marker line, it is much more reader-friendly:

A sample file for this option: Here 
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly