Filters

[Anonymous]

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?

[Greg_Deckler · Accepted solution]

@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. 

[Anonymous]

@Greg_Deckler  i did that before but was wondering if there is any other option. Thanks anyway.

[Greg_Deckler]

@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?