Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
There is a trick you can do to make this work 🙂
I've created the solution in this blogpost
https://www.villezekeviking.com/how-to-combine-a-clustered-and-stacked-chart-in-power-bi
Hi @Anonymous ,
In Power BI Desktop, it’s not possible to create a chart which can combine both Clustered and Stacked column chart together. Because it can’t determine which group of series need to be “clustered”, which group of series need to be “stacked”. And it’s 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:
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 133 | |
| 88 | |
| 85 | |
| 68 | |
| 64 |