Disable particular slicer value based on another slicer selection

[Anonymous]

I have 2 slicers. 1 Represents MTD/QTD/YTD/Custom and another is comparison slicer PM/PQ/PY.

I wanted to write a measure such that if MTD is selected, comparison slicer will show PM and PY, in case of QTD, only PQ and PY and for YTD and custom, Just PY.
Can it be done on visual filter level? 

[Anonymous]

Thanks @amitchandak , It worked nicely.

[amitchandak · Accepted solution]

@Anonymous , Create a measure on the table of the second slicer and then use that in visual level filter

Switch(True(),
max(S2[Col]) in {"PM", "PY"} && selectedvalue(S1[col]) = "MTD", 1,

max(S2[Col]) in {"PQ", "PY"} && selectedvalue(S1[col]) = "QTD", 1,

max(S2[Col]) in {"PY"} && selectedvalue(S1[col]) = "YTD", 1,

0)

Choose value =1 for this measure in the visual level filter of slicer

Refer

How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8