Forum Discussion

mohamedm's avatar
mohamedm
Frequent Visitor
1 year ago
Solved

How to add multiple Slicer

Hi Team,   Im doing a report to verify the users. lets say i have 50 users i have made a table that can select users; once it is selected automatically, it will come to another table using Slicer. ...
Need Help
  • MattiaFratello's avatar
    MattiaFratello
    1 year ago

    Hi mohamedm 

     

    in your case please use

    Filter 1 =
    IF(
        ISFILTERED('Name'[Employee Name]),
        IF(
            MAX('**bleep** Access Control'[Employee Name]) IN VALUES('Name'[Employee Name]),
            0,
            1
        ),
        1
    )
mohamedm's avatar
mohamedm
Frequent Visitor
1 year ago

ijust checked again selected is working but im not getting not selected list, i just need like below if any more country got selected , in selected list it should get add and remove from un selected table 

 



MattiaFratello's avatar
MattiaFratello
Super User
1 year ago

 

Filter = 1 in one table

Filter = 0 in the other table

Using the formula provided above

No relationship btw the tables

 

Please check, it should work

 

Did I answer your question? Mark my post as a solution!