Forum Discussion
Drill through with multiple selection. How to mass select values?
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!
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.Yes, I want to select all records in a visual (for example a table visual, or possibly another) and then use that to drill through.
Example:
On the below bar chart, select the "Well Below Proficient" performance level. This provides a list of students in the table visual on the right. I think, ideally, I'd want to do a "Select All" on the list of students in the table visual to the right and use that list of students as the drill through.
This list of students could be many records, so individually selecting them would not be feasible for an end user. In the below example, I would want the drill through to pass on the DistrictStudentKey values of 2 and 3.