Forum Discussion
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...
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.
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.
Perfect! It is working as I like 🙂 Thank you very much.