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.
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.
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.