Forum Discussion
switching between slicer filters
I have two slicers, one for absolute date, and one for relative date. If left alone, the data displayed will be that which meets both slicers. I'd like to be able to enable only one slicer at a time,...
lbendlin
Super User
Super UserThere's your answer. Remove the slicers and buttons. Put the date column in the filter panel. Teach your users how to use it. Allow users to change the filter type so they can decide when to use absolute or relative filtering.
That would be a perfect solution if it weren't for one other thing I didn't mention. The report is shared with teachers via our MIS. This lets them see and interact with the report, but peripheral functions like those filters and printing pdfs of the reports aren't available this way.
At the moment I've just left a note to clear the filter that the user isn't using. I suspect this might be a bit too unique a situation for an easy answer, but thanks for your help.