Forum Discussion
trev_likes_PBI
9 years agoRegular Visitor
Clustered stacked column chart
I'm trying to implement a Clustered stacked column chart. I can't figure out how to do it or find any examples. The chart would look similar to the image below. Have you got any idea if this can ...
- 9 years ago
trev_likes_PBI
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. The expected result as you posted can’t be achieved. For your requirement, I suggest you add a column to assign type “Forecast” and “Actual”, then build a hierarchy like “Type->Cost”. Put the hierarchy on X-axis, you suppose to drill down the detail level to see those different costs.
Best Regards,
Angelia
Anonymous
8 years agoNot applicable
Is there any update on this feature we too need this functionality/workaround if any one has done it