I would like to filter a table by clicking on a cell in the same table. Is this possible in Power Bi? If there is an alternative please let me know.
Thanks for any help!
Go to Solution.
What if you give them a top table with just the departments and a bottom table with the client department list. They click on the top table and it filteres the bottom, something like this:
View solution in original post
You could do that with a slicer on the Department field but that is the only way I know of to do what you are looking for.
They want a display to interact with 😞
Hi @MartyMcfly810 ,
We can try to use Drillthrough as a workaround to meet your requirement. First of all, complete other visuals in this page, then duplicate the page,
In the new page, put the field you want into the drill through field,
When you right-click the field in page one, you can go to the page which looks same with the filter you want.
BTW, pbix as attached.
Best regards,Community Support Team _ Dong LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is what I ended up doing. It was a simple alternative. Thank you!
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!