Forum Discussion

Pfoerster's avatar
Pfoerster
Icon for Helper III rankHelper 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 choos...
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.

     

MFelix's avatar
MFelix
Icon for Super User rankSuper 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
    Icon for Helper III rankHelper III
    5 years ago

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