How to use a Table for page filtering

[Anonymous]

Hello all of you brilliant folks, I have a puzzle for your creative minds.

I would like to use a single-column Table object for user interaction instead of a Slicer in List format. I've included a pbix to explain, but Table objects look much nicer and are easier to read, however, the selected value(s) do not drill-through to other pages like a Slicer would. Is there a way to do this such as a hidden Slicer that uses the same selected value(s) as the Table?

Instead of using this:

I'd like to use this:

PBIX file to play with:

https://www.dropbox.com/s/13utzp011kvjov5/Community%20Questions.pbix?dl=0 

Much thanks!!
Nick

[amitchandak]

@Anonymous , If you do Ctrl+click on Table, it filters other visuals on more than one item. Check the same with Drill through

[Anonymous]

You're right, and that filters fine one that same page. How do you get that select value(s) (one or many) to go to the next pages? I tried the adding the field to the drill-through fileds area (starting with the destination page), but that doesn't work.

[amitchandak]

@Anonymous , I tried out, Drill Through did not work with multiple selections. I tried with the button too, Drill Through button got disabled when I selected multiple values on the table using ctrl.  And Page Navigation option did not pass it correctly.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drill-through-buttons

Need to suggest an idea. https://ideas.powerbi.com/ideas/

[Anonymous]

You are correct. That's the issue I've run into also. So it begs the question, have any thoughts that might make that work? 🙂