cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MartyMcfly810 Frequent Visitor
Frequent Visitor

Is it possible to filter a table from same table?

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. 

 

Before:

Example 1.PNG

After:

 

Example 2.PNG

 

Thanks for any help!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Is it possible to filter a table from same table?

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:

FilterTables.jpg

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Is it possible to filter a table from same table?

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.

MartyMcfly810 Frequent Visitor
Frequent Visitor

Re: Is it possible to filter a table from same table?

They want a display to interact with 😞 

Super User
Super User

Re: Is it possible to filter a table from same table?

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:

FilterTables.jpg

View solution in original post

Community Support Team
Community Support Team

Re: Is it possible to filter a table from same table?

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,

 

10.PNG

 

In the new page, put the field you want into the drill through field, 

 

11.PNG

 

When you right-click the field in page one, you can go to the page which looks same with the filter you want.

 

12.PNG13.PNG

 


BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MartyMcfly810 Frequent Visitor
Frequent Visitor

Re: Is it possible to filter a table from same table?

This is what I ended up doing. It was a simple alternative. Thank you!

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,725)