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.
Dynamic display of graphs:
data sets: Vertical 1, 2, 3 4 ;
sub level data - > V1 - g1, g2, g3, g4 ; V2 - g2,g4,g6 ; V3 - g4, g7. These will be in dropdown one after another.
When I select V1, it should display 4 parameters such as Attrition, Headcount and other 2, through graphs (line, area or any other) comparing FY 18, Fy 17, for each of the "g" under v1.
Hi @Anonymous,
Could you please share some sample data to have a test and post your desired result if possible?
Regards,
Daniel He
Thank you for the response Daniel. Apologise for the delayed response. Below is the dataset:
Jobcode | Queue | Metric1 | Metric2 | Metric3 | Metric4 | Metric5 | Financial year |
38434 | Queue1 | 5000 | 3.40% | 5000 | 5000 | 5000 | FY 18 |
38434 | Queue1 | 5000 | 3.40% | 2900 | 5000 | 5000 | FY 17 |
38434 | Queue2 | 3000 | 4.40% | 3000 | 3000 | 3000 | FY 18 |
38434 | Queue2 | 4000 | 4.40% | 4000 | 4000 | 4000 | FY 17 |
38434 | Queue3 | 6000 | 3.50% | 6000 | 6000 | 6000 | FY 18 |
38434 | Queue3 | 3000 | 4.50% | 3000 | 3000 | 3000 | FY 17 |
38434 | Queue4 | 5000 | 7.40% | 5000 | 5000 | 5000 | FY 18 |
38434 | Queue4 | 5000 | 7.40% | 5000 | 5000 | 5000 | FY 17 |
38434 | Queue5 | 4000 | 3.30% | 4000 | 4000 | 4000 | FY 18 |
38434 | Queue5 | 2300 | 3.30% | 7800 | 3700 | 2300 | FY 17 |
38434 | Queue6 | 7000 | 5.40% | 7000 | 7000 | 7000 | FY 18 |
38434 | Queue6 | 3000 | 6.40% | 3000 | 3000 | 3000 | FY 17 |
78634 | Queue1 | 5000 | 3.40% | 4000 | 4000 | 4000 | FY 18 |
78634 | Queue1 | 5000 | 3.40% | 2900 | 5000 | 5000 | FY 17 |
78634 | Queue2 | 4000 | 4.40% | 2000 | 2000 | 2000 | FY 18 |
78634 | Queue2 | 7800 | 6.40% | 4000 | 4000 | 4000 | FY 17 |
78634 | Queue3 | 7000 | 3.50% | 6000 | 6000 | 6000 | FY 18 |
78634 | Queue3 | 3000 | 2.50% | 9000 | 2000 | 3000 | FY 17 |
78634 | Queue4 | 4000 | 7.40% | 5000 | 5000 | 5000 | FY 18 |
78634 | Queue4 | 2900 | 4.40% | 8000 | 1000 | 5000 | FY 17 |
78634 | Queue5 | 2000 | 3.30% | 4000 | 6000 | 4000 | FY 18 |
78634 | Queue5 | 4000 | 8.30% | 8800 | 3700 | 2300 | FY 17 |
78634 | Queue6 | 6000 | 3.40% | 2000 | 2000 | 7000 | FY 18 |
78634 | Queue6 | 5000 | 2.40% | 3000 | 1000 | 3000 | FY 17 |
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 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |