Forum Discussion
How to use a Table for page filtering
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
4 Replies
- amitchandak
Super User
Anonymous , If you do Ctrl+click on Table, it filters other visuals on more than one item. Check the same with Drill through
- 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/
