Forum Discussion
Cascading Slicers
Hi All,
I've implemented Exclude slicer selection with independent table logic.(copying the dim table having no relationship with any other table in the model and using except function)
Now I want to cascade that slicer(from independent table) with other slicers. If there is a relationship with fact we could have used Not is empty() logic - but it seems not possible here. Any help would be appriciated.
Thanks in Advance.
1 Reply
- amitchandak
Super User
Anonymous , Create a measure on the fact using this independent slicer.(it should filter fact data)
And then use that measure as a filter for all other dependent slicers and check for value is not blank
You need to use this measure in visual level filter of slicer and check for non blank value
