Clustered bar chart to represent the total value split into different categories.

[Anonymous]

Hi All,

Bar chart with multiple column reference 

@amitchandak 

This is with reference to this query (Bar chart with multiple column reference) which I posted long back, in which some more alteration required

I was able to build this clustered bar chart by refering to this blog:

https://clicktime.symantec.com/15uBsNTx8rpLSZDVY1tTm?h=Uqr-Tht5XTpFpqEI_Ub9SVggrmFQO7JBlSdWCXZXZfc=&....

I need a variation on this chart by spliting the bar chart into two were the total gives the count in which each bar shows splitted (with color variation) sum based on a column value . Total value is 60 = (45 +15 ) , where 45 and 15 belong to different va;ues of the same dataset.

Already built chart 

New requirement (I have done only for Nov month for reference, looking forward for help.)

[Anonymous · Accepted solution]

Hi @Anonymous 

What you want to create is a Stacked Clustered Chart, you can try some custom visuals to get the expected result. For example,

• Stacked Clustered Chart
• Clustered Stacked Column (Standard)
• Clustered Stacked Column Chart (Pro)

To access the app store in Power BI Desktop, in the Visualization pane select the ellipsis, then select Get more visuals.

Hope this helps!

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!