2 slicers based on the same field/column, but should exclude first slicer selection

[kkalyanrr]

Hello Team,

I'm looking for a solution to the below issue, please help..
Both slicers X1, X2 are based on the same column/field..but my requirement is when I pick a person from first slicer..that name should disappear in second slicer...any idea on how to implement the logic here..
Thanks.

[v-yueyunzh-msft · Accepted solution]

Hi , @kkalyanrr 

I didn't find the way to realize it in the slice. The reason is as follows:
(1)Measures cannot be placed in slicers.

(2)Tables don't have a filtering context, and we can't generate a table dynamically

We ca realize it in the table , If this helps you, you can refer to it:

(1)This is  my test data :

(2)We can click "New Table" to  create another table:

Table 2 = VALUES('Table'[test])

(3)We can create  a measure :

Measure = var _slice= VALUES('Table'[test])
return 
IF( SELECTEDVALUE('Table 2'[test]) in _slice ,0,1)

(4)We can put the 'Table'[test] in the slice and the 'Table2'[test] in the table, then we need to configure the "Filter on this visual" in the table, like this:

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly