Filter table data itself in table visual based on user click

[Mel_aus]

Hi

i have 1 table visual i want to filter data on that single visual when user click on a row inside table then it will filter and show that data.

Example of my table

main_id   id

A              1

A              2

A              3

B              4

B              5

C              6

So i want to click on main_id to filter the table visual. In above example if i click on main_id =A then table visual filter only to A and show 3 rows. I want to create click base experience for user not filter based. Thanks

[V-yubandi-msft]

Hi @Mel_aus ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[V-yubandi-msft]

Hi @Mel_aus ,

 @HarishKM , solution meets your requirements. Please review it and let us know if you have any additional details. If your issue is resolved, kindly mark it as the accepted solution to help others facing a similar issue in the community.

Thanks..

[pankajnamekar25]

Hello Mel_aus

The default behaviour in Power BI does not support filtering a table visual based on a row click. To achieve this functionality, you need to use a slicer.

If you want to highlight the selected main_id within the same table rather than filtering it out, that can be done. However, to apply actual filtering, a disconnected table is required, but it still needs a slicer for user interaction.

Another approach is using Bookmarks and Buttons, but this is not recommended if there are many main_id values, as it would require creating multiple bookmarks and buttons manually.

Thanks,
Pankaj

If this solution helps, please accept it and give a kudos, it would be greatly appreciated.

[Mel_aus]

Thanks Pankaj i was thinking if its possible to use DAX selectedvalue or something like that

[HarishKM]

@Mel_aus Hey,
you can use a brand new button slicer in Power bi. this will solve your required problem.

Thanks
Harish M
Did I answer your question? Mark my post as a solution. Appreciate your Kudos 🙂

[Mel_aus]

Thanks for reply Harish. I tried the solution but its not filtering table values. My requirement is to click on table visual value and it should hide all the other values and only show that single value and when i unselect that row it will return all the data. 

[V-yubandi-msft · Accepted solution]

Hi @Mel_aus ,

Thank you for your  clarification. You are seeking a feature where clicking a row in a table visual filters the same table to display only the selected rows.  This is referred to as a self-filtering table or an interactive drill-in experience.

At present, Power BI does not support this functionality  table visuals can only receive filters, not apply them to themselves.

I recommend submitting your idea or supporting a similar request on the Power BI Ideas Forum. Microsoft actively reviews community feedback there, and popular ideas are often considered for future updates.

Fabric Ideas - Microsoft Fabric Community

 If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

[mdaatifraza5556]

Hi @Mel_aus 
Can you please provide some samples you want to achieve?

[Mel_aus]

Thanks for quick reply. I got simple table mentioned above. i just want to filter out all other main_ids when i click on row where main_id =A. So if i click on row where main_id is A it should only show rows and when i deselect that row then it will return all rows back.