Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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

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=&u=https://youtu.be/e6Y-l_JtCq4.

 

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's avatar
    Anonymous
    2 years ago

    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,

    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!

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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,

    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!