How to combine a stacked and clustered column chart

[Anonymous]

Dear Power BI community,

I would like to create a chart that is a comination of a stacked and a clustered column chart, as in the picture below.

- The clustered bars devide the prices of two different parties.

- The stacked bars devide the original price with the mark-up of one party.

Does anyone have an idea how to go about this?

Kind regards,

[Villezekeviking]

You can also create it like this:

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

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

You can use the Clustered Stacked Column to achieve it.

In Power BI visualizations pane, click three dots then select "Get more visuals".

I attach a sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[yashwant101]

Hi @v-yanjiang-msft ,

I checked the microsoft verified one out of the visual, there is option to have only two clustered charts. Moreover, it is a paid visual. Do we have any other alternatives?

[DeanTCC]

It is possible to do this using Error bars in the analytics pane with a few limitations such as Legends and Tooltips not showing the "Stacked" bits