Stacked chart help

[Anonymous]

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?

[Anonymous · Accepted solution]

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]

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

[Anonymous]

Hi @Anonymous ,

You can try to use Clustered Stacked Column Chart.

More details:Create Clustered Stacked Column Chart for Power BI | PBI VizEdit

Power BI Clustered Stacked Column Bar | DEFTeam | Power BI Chart

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.

[Anonymous]

@Anonymous Do i need to buy this clusterd Stacked Column chart?