Forum Discussion

Pfoerster's avatar
Pfoerster
Helper III
5 years ago
Solved

Stagged Bar Chart with multiple values

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? 

Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    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.

     

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    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's avatar
      Pfoerster
      Helper III
      5 years ago

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