How to make matrix header 'click'/filter rows with data

[JesseV]

Hey everyone,

I have a matrix with values, but not all datapoints have data (which is intended).

What happens now when I click 004: 

What I want to happen when someone clicks 004:

Can this be done from the matrix visual? (I currently have a workaround with a seperate table which then filters the matrix, but this doesnt work as well).

How can I set this up? 

Thank you in advance for any ytouble to be taken. 

[amitchandak · Accepted solution]

@JesseV , Only a separate visual or slicer can filter value of another visual , or try right click include

[JesseV]

Hey Amit,

The right mouse click->include option is a workable solution, one that I didnt know about!

thanks a bunch!