cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andrehawari
Helper II
Helper II

Double Stacked Column Chart / Combination of Stacked and Column Chart

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

Capture.PNG

 

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

 

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

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

10.png

9.png

 

Best Regards

Maggie

View solution in original post

6 REPLIES 6
Ville
Helper I
Helper I

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
Frequent Visitor

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
Regular Visitor

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.

Clustered-Stacked_1.png

 

 

 

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

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
Community Support
Community Support

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

10.png

9.png

 

Best Regards

Maggie

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.