Change slicer settings dynamically to single selection

[dyeraker]

Hi, 

I'm looking for help for an issue I've been stuck with for a couple of days now. I have two slicers where slicer1 only accepts two values (option1 and option2) and slicer2 has multiple values. I'd like to allow multiple values to be selected in slicer2 at once, if option1 is selected in slicer1. However, if slicer1 is set to option2, I'd like to limit slicer2 so that only one option can be chosen at a time.

Is there any way to do this? 

Thanks in advance!

[v-zhangti · Accepted solution]

Hi, @dyeraker 

You can try the following methods.

Measure = SWITCH(TRUE(),
SELECTEDVALUE(Slicer1[Slicer1])=BLANK(),1,
SELECTEDVALUE(Slicer1[Slicer1])<>BLANK()&&SELECTEDVALUE(Slicer1[Slicer1])=SELECTEDVALUE(Slicer2[Slicer2]),1,
0)

Result: The choice of Slicer2 does not affect Slicer1, but the choice of Slicer1 will limit Slicer2.

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ray_aramburo]

Not at the moment, selection configuration is exclusive to each slicer.