Line Chart Toggle Legend

[JackyChoi]

Hello,

I am trying to create a button to toggle the display of my line chart.

Imagine a public school dataset with 3 hierarchy.

Level, Class, and Student

Ex. 

Level 1 can have multiple classes, and each class can have different number of students

In another word, student must be in a class which belong to a level.

Now, let's say I have a dataset of each student' performance and I would like to plot them on a line chart. What I really want to do is to have a line graph which shows the grades by level. The user can then select the level they want to see and the line graph will plot it by classes. The user can then futher select which class they woud like to see to understand each students performance.

So what is the best way to do this?

Thanks

[ankitpatira · Accepted solution]

@JackyChoi Drill-down in power bi would best suit your requiremet. Check out more about them here.