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

Question

Hi Everyone!&nbsp;This is my first time posting here and I've tried reading and researching for this concern but, to no avail.&nbsp;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.&nbsp;Trying to visualize it as seen below&nbsp;&nbsp;Matrix Table 1&gt; Idea is, when I select the value highlighted in yellow (Channel AAA ; Category 111)&nbsp;&nbsp;Matrix Table 2&gt; Should not show the values in red because it has Channel AAA with Category 111&nbsp;&nbsp;Therefore expected view of Matrix Table 2 is as seen below&nbsp;&nbsp;Looking forward to any inputs here.&nbsp;Best,Gilded

anonymous · Accepted Answer

HI&nbsp;Anonymous,
It seems like you want to achieve the&nbsp;reverse&nbsp;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

Forum Discussion

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

1 Reply

Related content

Matrix table

sorting matrix

Customize subtotal in matrix

Matrix formatting

Specific matrix