Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Filter table data itself in table visual based on user click

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

Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    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.

9 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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.

  • pankajnamekar25's avatar
    pankajnamekar25
    Super User
    1 year ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

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

      • HarishKM's avatar
        HarishKM
        Super User
        1 year ago

        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 🙂

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    1 year ago

    Hi Anonymous ,

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

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    1 year ago

    Hi Anonymous ,

    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.