Forum Discussion
Solved
dependent slicers
let say i have two slicers in report - one is for selcting "Year" and another is for selecting "City", requirement is user should not allow to select values in "City" slicer until and unless atleast ...
You can use a measure that checks whether the first slicer columns is filtered and return a valeu if it does. Use it as visual filter for the second slicer.
Slicer Filter = IF ( ISFILTERED ( Reseller[Business Type] ), 1, 0 )
You can use a measure that checks whether the first slicer columns is filtered and return a valeu if it does. Use it as visual filter for the second slicer.
Slicer Filter =
IF ( ISFILTERED ( Reseller[Business Type] ), 1, 0 )