Stagged Bar Chart with multiple values

[Pfoerster]

Hello,

again, I am struggling at transforming an EXCEL Report into Power BI:

I would like to create this kind of bar charts, and I have following problem:

As Legend of the Bar Chart, I choose my Territory, so I get the "Americas, Emena, APA/China"... everything fine but:

the volumes, based on the different Scenarios (ACT 19, BUD 20, SUF 20, ACT 20) are all calculated measures. Therefore, I can only put one of these 4 into the Value of the Bar Chart Visual. 

And I can not put the Scenario into the Axis of the Bar Chart, because then, I do not have the ACT 19, because in my Dataset, I only have the BUD, SUF and ACT as Element of the Scenario Column.

Is there any workaround, how I can visualize my 4 calculated Measures as a stagged bar chart, based on territory? 

[MFelix · Accepted solution]

Hi @Pfoerster ,

Create a disconnected table with the following data:

Now create the following measure:

VALUE = SWITCH(
                SELECTEDVALUE('AXIS'[ID]); 
                1 ; [ACT 19];
                2; [BUD 20];
                3 ; [SUF 20]; 
                4; [ACT 20]
            )

Build you chart with the following setup:

Axis: X-Axis Column

Legend: Territory

Values: Measure Value

Result below and in attach PBIX file.

[Pfoerster]

Perfect! It is working as I like 🙂 Thank you very much.