Multiple measures/values on Y-axis of stacked column chart with legend already taken by country

[rpinxt]

This is the situation:

So I have data in with Type Actual. Now we will load also LBE1, 2 etc.

If I would put 'Type' in the legend I would get a column for every Type.

That is what we want but we also would like the countries stacked like in this picture.

Is it even posible to have this setup, so with period on x 'Volume' on y and country in legend, and still have multiple values on Y?

Was thinking of making a switch with 'ACT Vol' "LBE1 Vol" etc and depending on the type selected it would put that on Y.

But I fear it will only sum Actual and LBE together instead of making separare columns correct?

[rpinxt · Accepted solution]

Thanks @Anonymous but I used the x-axis! Put period and type on the x-axis and this was I get 2 columns per period. One with the actuals other with LBE:

Too fixated on the y-axis to show 2 different volumes. But the key was in the x-axis spliting the volume into a type.

(note: you need to have a column in your data that determines if an amount is an actual or an LBE)

[Anonymous]

Hi @rpinxt ,

Please try to use field parameter, this may be could help you.

For more details, you could read related document: Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.