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

Great it seems working now, but only one issue its not getting select all, Once i selected only its getting remove from first table and adding into next table 


Once i select 2 its just updating only latest 

i just need everything to be listed