Forum Discussion

trev_likes_PBI's avatar
trev_likes_PBI
Regular Visitor
9 years ago
Solved

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 ...
  • v-huizhn-msft's avatar
    v-huizhn-msft
    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

Riv's avatar
Riv
Advocate I
3 years ago

I'm trying to use this tool and can't figure out how to add the clustering variable. How do you add a clustering variable?

asitm's avatar
asitm
Helper III
3 years ago

Hi Riv 

Instead of creating with the editor, now there is a direct download option available.
You can directly download the clustered stacked column chart from Appsource. There is a non-certified and a certified version.

https://appsource.microsoft.com/en-US/product/PowerBIVisuals/yavdaanalyticspvtltd1628223732998.clusteredstackedcolumn

https://appsource.microsoft.com/en-us/product/power-bi-visuals/yavdaanalyticspvtltd1628223732998.clusteredstackedcolumnpro?tab=Overview


if you need a modification to the standard one and have to use the editor, then let us know and we can get you help.

Regards,
AsitM