Forum Discussion
Filter table data itself in table visual based on user click
Hi Anonymous ,
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.
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.
Thanks Pankaj i was thinking if its possible to use DAX selectedvalue or something like that
Anonymous 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 🙂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.
