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