Only Allow Use of One Slicer at a Time

[agalbraith]

I looked through the forum and could not find the answer. I have three separate chiclet slicers on each page. We want users to only be able to use one slicer at a time, because when you click on multiple slicers across the 3, the data gets too sparse (goes blank because we limit response to 5 or more respondents). How do I do this? I thought it was to turn off the interactions among the slicers but that only means they don't filter each other, not the ability to only use one at a time. 

[agalbraith · Accepted solution]

for anyone looking into this as well I found this solution and it worked for me!

https://community.powerbi.com/t5/Desktop/When-selecting-one-slicer-other-slicer-gets-disabled/m-p/21...

[rsbin]

@agalbraith,

I'll try to lay out a potential work around to your problem. 

Create a measure for each of your Slicers:

Slicer1 = IF ( ISFILTERED [ColumnName1] = TRUE(), 1, 0 ) 
Slicer2 = IF ( ISFILTERED [ColumnName2] = TRUE(), 1, 0 ) 
Slicer3 = IF ( ISFILTERED [ColumnName3] = TRUE(), 1, 0 ) 

I believe the Chicklet Slicer allows for conditional Titles.  So you can create a title measure something like this:

Title_Slicer1 = IF (OR (Slicer2 =1, Slicer3=1), "DO NOT USE", "Your Title" )
Replicate for the other 2 Slicers.

Not sure if my syntax is exact, but hope you get the idea.  A SWITCH Statement may work better.

This won't disable the Slicer, but at least you can give the User a Warning Message, so as not to use multiple slicers.

Regards,

[agalbraith]

I'd like to try this but I am getting an error when typing in the measures saying "too many arguments were passed to the isfiltered function. the maxium argument count for the function is 1"

[rsbin]

Good Morning @agalbraith ,

I am not an expert at writing syntax on the fly.  You will need to search how to properly write it out.

I am probably missing a set of parenthesis somewhere in there.  Just test out the syntax for the ISFILTERED function without the IF.  Once you get that working, then throw in the IF Statement around it. 

Hope you can get it to work. 

Regards,

[AlexisOlson]

I don't think there is a simple way to do this but I bet you can cook up a solution using buttons and bookmarks where, for example, you only have one slicer visible at a time and switching bookmarks to a different slicer resets them.