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
    )
MattiaFratello's avatar
MattiaFratello
Super User
1 year ago

Hi mohamedm ,

 

Create a table with distinct employees (make sure to not have an active relationship with your current table).

Use the distinct employee column from your new table in the slicer.

Create two identical tables from your main table, in one of them set this filter =1 (you are going to create this filter throug DAX Measure).

 

Filter = 
IF(
    ISFILTERED('financials (2)'[Country]),
    IF(
        MAX(financials[Country]) IN VALUES('financials (2)'[Country]),
        0,
        1
    ),
    1
)

 

 

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

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!