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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Filter table by clicking column

https://community.powerbi.com/t5/Desktop/Filter-table-by-clicking-on-column/m-p/294527#M129910

I found this topic and there was no answer to if this is possible (maybe with updates now?)

You can format visual interactions, meaning that if you click in a column another visual will only present what you clicked on.

Is it possible for me to click a column in a matrix table and have a filter enabled for that table. I don't mean greying out I mean actually showing all values related to the column I clicked?

 

Example (sensitive info so I can't show the table)

Below shows: Description, Relation and Entrynumber.

image.png
I open a description, then I click on a relation row. This relation is present in more than one description.

I want the table to be filtered this specific relation and open all descriptions where this relation is present.

 

It's possible with right-click > drill down and then removing the upper filter as shown below
image.png

But I want to remove those inbetween steps..

I hope this makes sense, let me know if it's unclear.

2 REPLIES 2
Anonymous
Not applicable

HI @Anonymous 

Create a sample data and share what you see and what you expect.

Help can be offered when asked with facts, tables and issues.

Greg_Deckler
Community Champion
Community Champion

@Anonymous - Extremely difficult to follow but maybe a report page tooltip? You could pass in the informatioon you needed to the tooltip but override context if necessary.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors