Forum Discussion

MostafaGamal's avatar
MostafaGamal
Icon for Helper V rankHelper V
6 years ago
Solved

How to make a relation between 2 slicers

Hi all,  If i have 2 slicers and each one using a column in a table ( 2 separate tables ), how to make the choice in the second slicer is equal to the choice in first slicer , Plesae advise    ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi MostafaGamal 

     

    I would not create a second slicer instead I would create a measure and use it in the 'Filter on this visual' section of the chart(s).

     

    _filter = IF('Table1'[Department]=SELECTEDVALUE('Table2'[Department]),1,0)

     

    Filter it to display only for value 1.

extrasiyf's avatar
extrasiyf
Frequent Visitor
5 years ago

Anonymous If I create a measure, I cannot put columns inside (like  'Table1'[Department]) what is the solution ?