How to make a relation between 2 slicers

[MostafaGamal]

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 

[extrasiyf]

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

[lbendlin]

Your data model does that automatically if the tables are linked. Every visual impacts every other visual unless you specifically tell them not to.

Note: What you are doing here is creating a bad (confusing) user experience.

[MostafaGamal]

@lbendlin @I don't want to make a relation between the 2 tables because that affects other charts and measures I was wondering if there a way to make the choice of second slicer is the choice in first slicer without creating any relation

[lbendlin]

Please don't.  Use a single slicer and then control the second table with measures that use SELECTEDVALUE() probing on the slicer.

[Anonymous · Accepted solution]

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.