Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Clustered Stacked Column chart with individual values stacked

Hi,

 

I am trying to plot the data as shown in fig below.

 

 

But I don't see visual for a stacked and clustered column chart. There are two separate visuals for both of them. I need to draw second stacked bar with individual values on top of each other and that compares to the values in first column with single value, something like a comparison of the two columns.

 

Is there any feasible solution to this in Power BI because in excel you can tweak the two charts types but not here or something that I am unaware of?

Need Help

10 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Anonymous 

    Try custom visual   "Dril Down Combo Pro By ZoomCharts"  .

     

    You need to manually define the format of some fields .

    Please check atteched file for more details.

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks v-easonf-msft 

       

      That does work. However, this requires a license to purchase its pro features. Further, the custom "Stack" settings you specified, I don't find them in my Desktop opened pbix. It seems that stack settings are again for pro license.

       

      Can it be there any other custom visual that does not require any license purchase?

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi， Anonymous 

    Sorry,I haven't find  any other custom visual  that meets your requirements  currently. 

     

    I am also a trial user. If you have not used this custom visual before, then when you open the report, you will automatically have the access to the paid features for 30 days.

     

    Please check the following steps:

    1) select  the visual to active  it ->  2)select the "format" pane ->   3)select "series 3 Configuration" 
    Then you will  find the custom "Stack" settings

     

     

    Best Regards,
    Community Support Team _ Eason

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      That is absolutely fine v-easonf-msft .

       

      And thanks for your efforts in solving my problem. I really appreciate that.

       

      I did figure it out myself where the stack settings needed to be configured. Thanks again for explaining me the settings in detail here.

       

      You saved my day, you rock :).

      If you come to know of any free visual for this kind of problem, please do drop me a line about the same.

       

      Thanks again,

      Best Regards,

      Nitin

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      The problem with this is that you see two different columns with identical set of values viz. "Forecast" vs "Actual" and each split into equal number of stacks. In my case, I have two columns viz. "Committed" vs "Actual". Where "Committed" column is a single stack while "Actual" column is stacked into three individual bars. Hence, the data plot is not the same. Further, I have a single row for different sprint or Country against each individual values in my table. So, another ggplot2 approach is also not plotting the chart as the way I need it to be.

       

      Looking for some good alternates as of now....any help is appreciated.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I am attaching my sample pbix so that it can be referenced as to what I am trying to make it as.

    The report contains two tabs, "Plot to draw" and "Plot available in PBI". Hope it explains my purpose.

     

    Clustered Stacked Bar Sample PBIX