Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsPerfect! It is working as I like 🙂 Thank you very much.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |