If selected in the Matrix Table 1, Then do now Show in Matrix Table 2

[Anonymous]

Hi Everyone!

This is my first time posting here and I've tried reading and researching for this concern but, to no avail.

Here's the situation, I have 2 matrix tables showing relatively same data. My goal is when I select one value in the table, the other table should hide data related to the selected value in the previous table.

Trying to visualize it as seen below 

Matrix Table 1

> Idea is, when I select the value highlighted in yellow (Channel AAA ; Category 111)

Matrix Table 2

> Should not show the values in red because it has Channel AAA with Category 111

Therefore expected view of Matrix Table 2 is as seen below

Looking forward to any inputs here.

Best,

Gilded

[Anonymous · Accepted solution]

HI @Anonymous,

It seems like you want to achieve the reverse cross highlight between matrix visuals. AFAIK, the current power bi does not support these effects.
I'd like to suggest you create an unconnected table as the category of that matrix, then you can write a measure formula to compare two visual records and use it on the second matrix 'visual level filter' to achieve your requirements.

formula =
VAR selected =
    VALUES ( Table1[Customer] )
VAR _current =
    SELECTEDVALUE ( Table2[Customer] )
RETURN
    IF ( _current IN selected, "N", "Y" )

Applying a measure filter in Power BI - SQLBI

Regards,

Xiaoxin Sheng