Forum Discussion
Clustered stacked column chart
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
trev_likes_PBI I think in power bi using standard stacked column chart you won't be able to split out two columns but it will have different colours for each category of your legend. Something like below.
Thank you ankitpatira. However, a stacked column is not sufficient for what we are trying to implement.
You might want to think about using small multiples, i.e. splitting up the one chart into four small bar charts, one for each country.
If the data isn't too complex small small multiples in general work great to bring out differences among categories.
