Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Stacked chart help

I have clustered chart as shown below. I need to club last year case and epics resolved as one stacked with different colors. Epics created will remain untouched. Is it possible?    
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    You can get more details here.

    Power BI Desktop>>Get more visuals.

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anand24's avatar
Anand24
Icon for Super User rankSuper User
3 years ago

Hi Anonymous ,
You can't have 2 measures stacked and 1 measure unstacked in the same chart in Power BI.
2 alternative solutions:
1. Create a custom visualization and use it in your report - Very tedious solution since external coding expertise is required

2. Overlay 2 charts over one another - one chart would be clustured bar chart with Epics while 2nd chart would be a stacked bar chart with other 2 measures. Format both in such a way that it looks like 1 single chart. This method also has drawbacks that the charts should be static and the chart which is on back won't be clickable

 

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!
LinkedIn