Stacked Column Chart with multiple values?

[rpinxt]

Let me share my starting point:

So a nice stacked chart for our Actual Volumes by category.

Now we want also to bring in our Estimated Volumes.

Is it possible in a stacked chart?

So then we would have per month 2 stacked colums instead of one.

I know we can do it with a normal clustered chart but then I would lose the categories.

Was wondering if in a stacked chart you also could have multiple Y-axis

[Anonymous]

Hi @rpinxt ,

Accourding to my testing , stacked column chart doesn't support multiple Y-axis.

In power bi desktop, Line and stacked column chart can show value in Line Y-axis, like this:

Not sure if it can meet your needs, you can try. But I have to say that "stacked column chart" should not be possible to add more than one Y value.

If I misunderstood your meanings or have something wrong, please tell me in time. Thanks in advance~

Best regards,

Community Support Team Selina zhu

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

[rpinxt]

Ok thanks. Well if it cannot be done it cannot be done.

Was looking for Clustered Stacked graph.

Column/Line graph will not cover it good enough.

[Anonymous]

Hi @rpinxt ,

Have you solved youe question? Have you found the right visual chart to meet your needs?

I found a custom visual, it seems to be very similar to what you are trying to achieve and can have two stacked columns.

Best regards,

Community Support Team Selina zhu

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

[rpinxt]

@Anonymous thanks, I did see this custom visual too, but had a hard time getting it to work with my data.

Also the example was not very clear to me. Maybe if there was a good guideline how to use this visual or a demo.pbix file it would work.

[Anonymous · Accepted solution]

Hi @rpinxt ,

Hope these docs can help you:

Clustered Bar Chart in Power BI- Power BI Docs

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

Best regards,

Community Support Team Selina zhu

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