Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sky_limitless
New Member

How to filter row by a mouse click on the same table

Hello everyone, I'm wondering if it's possible to implement a filtering mechanism for a table or matrix with a simple mouse click. For example if this is the table:

sky_limitless_0-1696924239622.png

 

when I click on "Driver Jeff K, or the first row" the table would only show data for Jeff K and that row. like this:

sky_limitless_1-1696924418118.png

thank you so much!

3 REPLIES 3
Idrissshatila
Super User
Super User

Hello @sky_limitless ,

 

so when you click on a certain name in the matrix, it will show all the records as faded and show the record you clicked as clearly shown, but it won't hide the other rows and would show as your second screenshot.

so the only way it happens is that it gets filtered by a slicer or by the name from another visual.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Sandhya1234
Helper II
Helper II

@sky_limitless Use the Driver column in the slicer and when you are selecting any name in the slicer &  it will show in the table.

thank you for the feedback. is there a way to do it without using  Driver column in the slicer ?

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.