Forum Discussion

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
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

rajankamboj

Regular Visitor

7 years ago

Hi Guys

I know there is no provision to create a clustered stacked column chart in PowerBI directly. But at times we have no option but to create the same to meet project demand. We have tried to tweak a little and build something which is close to clustered stacked column chart to meet our requirement. I am sharing the screen shot for same. We created it using black columns. In case you want to know more about solution, do ping me @ [email protected]

https://app.powerbi.com/view?r=eyJrIjoiNzcyZTEyZjItOTRhMS00NmMwLWI2ZDktZTE0NzI2YTczN2YyIiwidCI6IjI4NTQxNGJhLWI3YTctNDhjNi04OTdlLTVmNDYwZGQxNDQ4YSJ9

Thanks

Rajan Kamboj