Forum Discussion
Filters
In my report I have 3 filters. However, if one of the filters is being used, I don't want the user to be able to use the other two at the same time. So there are three views, but only one can be used at a time. Is ther a way that could work?
Anonymous - Maybe if you had them click a button to activate which filter they wanted to use. So, create bookmarks that display each filter and hide the other filters (slicers). Tie your buttons to the bookmarks. User clicks a button to activate a filter.
3 Replies
Anonymous - Maybe if you had them click a button to activate which filter they wanted to use. So, create bookmarks that display each filter and hide the other filters (slicers). Tie your buttons to the bookmarks. User clicks a button to activate a filter.
Greg_Deckler i did that before but was wondering if there is any other option. Thanks anyway.
- @Shak85 Here's a thought, maybe you create a "selection measure" where you might use something like HASONEVALUE in your slicer and return 0 if so, but 1 otherwise. So, can you use this to filter out your other two slicers?