Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

Reply
JackyChoi
Frequent Visitor

Line Chart Toggle Legend

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

1 ACCEPTED SOLUTION
ankitpatira
Community Champion
Community Champion

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

View solution in original post

1 REPLY 1
ankitpatira
Community Champion
Community Champion

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

Helpful resources

Announcements
Fabric Data Days is here Carousel

Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.