cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Stacked Clustered Column Chart

Hi All,

Please see below graph :

 

I cannot add any column to the legend field since I have given two aggregations in the value field. Is there any way to do that or any other visual available which can act as a combination of clustered and Stacked column chart.

image.png

 

2 REPLIES 2
v-yingjl
Community Support
Community Support

Hi @Anonymous ,

In Power BI Desktop, its not possible to create a chart which can combine both Clustered and Stacked column chart together. Because it cant determine which group of series need to be clustered, which group of series need to be stacked. And its still not supported to add multiple fields into Legend of a chart. For your requirement, I suggest you to  add a column to assign types, then build a hierarchy. Put the hierarchy on X-axis, you suppose to drill down the detail level.

 

You can also refer the following similar cases that could help you:

  1. https://community.powerbi.com/t5/Desktop/Double-Stacked-Column-Chart-Combination-of-Stacked-and-Column/td-p/456690
  2. https://community.powerbi.com/t5/Desktop/Stacked-amp-Cluster-bar-chart/td-p/501432

 

Best Regards,

Yingjie Li

 

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

That doesn't make any sense. If I select one of the categories from another visual, Power BI is perfectly capable of representing it's proportion in my clustered column chart.

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors