Hi,
I assume a similar question may have been asked, though I'll take a chance and ask it again.
The scenario I'm trying to reproduce is being able to sync the reset of a series of 5 slicers displayed in a cascading pattern
The content of each slicer is obtained from a specific related field located on a same financial rates reference table.
The 1st slicer selection filters the content of the 2nd slicer, which then filters the content selection of the 3rd slicer,
which then filters the content selection of the 4th slicer, to finally filter the content of the 5th slicer.
I know this may not be best UI/UX option, but since the reference table contains a fair amount of combination rows,
using a table visual for display and selection would require the user to scroll down forever and end up with wrist tendinitis...
So the cascading slicers pattern seems to be working fine as last slicer displays the proper combo filtered content.
So my question is being able to sync a reset. That is, for example if I decide to uncheck the selection of the 4th
slicer, then 5th slicer would no longer display the previous selection but return to All...
If I uncheck a selected value in Slicer 3, then it would reset both subsequent Slicer4 and Slicer5 to All.
I'm not afraid of using DAX measures as filters, so if anyone has something to propose, then it would be deeply appreciated.
One last thing, some may suggest using the hierarchy slicer, however we haven't been granted the permission to use
ANY custom visuals....
Thanks
