Forum Discussion

MarkSmash's avatar
MarkSmash
Frequent Visitor
2 years ago

Drill through with multiple selection. How to mass select values?

Goal: To pass through a large number of individual student records to a drill through page.

 

Sample PBIX: https://drive.google.com/file/d/13rQyKv945RQ9agViVayFlxZ9Ieon4q_y/view?usp=drive_link 

 

Using visuals on the page (Test 2-Overall Score), I need a way to mass select and pass through to the drill through page (Attendance - Drill Through) the individual student records so that they can be filtered on that page. 

 

My thought is the best way to do this is using the card visual (source: https://www.purplefrogsystems.com/2021/02/power-bi-drill-through-using-multiple-data-points/), but I cannot figure out a clean/simple way to select the list of students to drill through to other pages.

 

Example steps:

1). On the bar chart, select the "Not Proficient" and "Well Below Proficient" performance levels across both terms. This selects only Full Names for 3 students (on right table).

 

2). I then need a way to mass select those 3 students, and pass through their Full Name's/DistrictStudentKey's only to the drill through page.

Manually selecting the student records on the table visual, or on the slicer, and then drilling through on the Card visual works, but this non-sample data could contain hundreds of student records we'd want to drill through so I'd want a simple way to mass select the students.

 

Very open to other solutions than the above if there is a way to select and pass through multiple records to another page. Synced slicer of the DistrictStudent table could also work, but to my knowledge there still isn't a way to mass select the required students easily?

Need Help

6 Replies

    • MarkSmash's avatar
      MarkSmash
      Frequent Visitor
      2 years ago

      Hi Daniel29195 

      Thanks for the reply!

       

      I have seen that video, and it actually references the page I had in the initial posting. Unfortunately my understanding is this method passes through the categories to filter the students to the drill through page, but that won't necessarily help if those drill through categories aren't related to the drill-through page.

       

      In an example from the sample PBIX file, selecting "Well Below Proficient" Performance Levels on a particular test to drill through isn't related to a dedicated Attendance page. This attendance page might be where I would want to evaluate attendance records related to that subset of students with Well Below Proficient on the test.

       

      Below is the screenshot of the filters being applied in the above drill through example. The attendance table visual below isn't filtering out the "A L1 (1001)" records.

       

       

      Instead of drill throughing the selected categories used to initially filter the records, I believe I need to find a way to pass the DistrictStudent records themselves to the drill through instead of the selected categories. But I'm not sure how to achieve that in a simple manner instead of manually clicking each record in the slicer or another visual listing out each student record.