Dynamic display of number of graphs based on selection of dropdown values from two or more dropdowns

[Anonymous]

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. 

[v-danhe-msft]

Hi @Anonymous,

Could you please share some sample data to have a test and post your desired result if possible?

Regards,

Daniel He

[Anonymous]

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