Forum Discussion
Drill through with multiple selection. How to mass select values?
Community Champion
please refer to this video: https://www.youtube.com/watch?v=s7PSwxdiwwE&t=104s
hope this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
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.
- Daniel29195
you can use this concept :
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
you can here use dax to get the filters that you want, and add them to the url paramters .
would this help you get what you want ?
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠Hi Daniel29195 ,
That is an interesting solution, and I am able to get it to work on my sample dataset published to the Power BI service.Before I mark this as the solution, are we then conceding there is no way to mass select the values in a visualization--for example a table visual? If there was a clean way to mass select all DistrictStudent.DistrictStudentKey values in a visual, the card drill through would then work with less overhead in maintaining these buttons.
Thank you for your help!
- Daniel29195
im a little confused by what do you mean by mass select ?
do you mean like selecting multiple rows from the visual table, and drillthrough ? because,
you can select multiple rows from the table, and then drillthrough the card visual.