two matrix - change right click filter

[paulohummel]

I have two matriz in a same page. the source is a tabela that gives me five dates , the product and the sale values.

the first matrix is filtered with the newest date. The other has al the dates.
I would like in some way that when a click at the first matrix,  the second will be filtered only by product, ignoring the date.

[paulohummel]

Helo, @amitchandak . I watched the video, but it still is not working.
The first vizualization is from a table that has only the highest value for date,

while the vizualizatino below has all the dates.  I used the solution from the video, but now the vizualization below has only one date, the highest value, just as the first one.

Do you know what i am doing wrong:

[amitchandak · Accepted solution]

@paulohummel , You might have to take help from a disconnected table

Power BI Partial Interactions, Selectively pass filter across visuals - https://youtu.be/SFEKQEic_sk