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

rajankamboj's avatar
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

 

  • pateam's avatar
    pateam
    Frequent Visitor
    7 years ago

    Hi Rajan,

     

    Please share more detils how you get this solution.

     

     

  • gkings1's avatar
    gkings1
    Regular Visitor
    7 years ago

    I am trying to implement the same chart in a report I am working on; can you share how you implemented the chart? Thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    rajankamboj  Please share the details of this as it meets what I and many others are trying to achieve

     

    Thanks in advance

  • Manash27's avatar
    Manash27
    Frequent Visitor
    6 years ago

    Hi Rajan,

     

    Can you please share the soluton(.pbix) to [email protected]. Help will be appreciated.

     

    Regards

    Manash

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi! Could you please share solution? I need to implement the same thing

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Has anyone gotten the solution?  I need to have this also

    Thank you in advance.

  • JTY's avatar
    JTY
    Frequent Visitor
    6 years ago

    hi 

    what was the solution ? i need to implement it as well in a file 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Unfortunately no,  I had to resort to the just using the clustered chart and having the multiple categories on the axis chart to allow for a drill down.

  • Deemo's avatar
    Deemo
    Advocate II
    6 years ago

    Hi rajankamboj  Can you please share the solution? Thank in Advance!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Can you share the pbix to my email - [email protected]

     

    Appreciate your help

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Unfortunately the solution suggested by rajankamboj never came with a pbix.

      The best offer came from LN7715 with a video on Youtube showing a possible way forward.

       

      I believe it's still an open request with the Power BI developers to give us an official solution.