Forum Discussion

Erin's avatar
Erin
Helper I
9 years ago

Interaction between two Slicers doesn't work well

Hi All,   I have two slicers(S1 and S2) with some visuals on one report , S1(City) and S2(Product), and S1 can control S2 but S2 can't control S1. S1 and S2 can control all other visauls. The inter...
Need Help
Sean's avatar
Sean
Community Champion
9 years ago

Erin If you remember I was with you on this!

 

First the bad news! :smileysad:

I think this is more about the principle - you have selected something in the slicers yourself!

Basically you have set the search criteria yourself!

They are not about to undo/clear YOUR selections!

As you can see in the picture you selected Dallas P1 and Houston P1

They don't want to clear your selections - you are the only one that can clear them!

In your example I guess the products are exclusive to those cities and its easier to see why you may not like the outcome.

Hope this makes sense!

If you have not selected something yourself and it does not apply it will disappear

however if you have selected something yourself it will show no matter what because YOU selected it yourself!

 

 

And now the good news! :smileyhappy:

I think I may have found a solution for you =>the Hierarchy Slicer

 

 

Hope this helps! :smileyhappy:

Erin's avatar
Erin
Helper I
9 years ago

Sean

 

Thanks for following and solution...

 

Hierarchy Slicer may not be a good way for my case. I have a huge data set with the dashboard, and large number of data in each slicer, and want to provide users a good way to see the options they can select from by filters.