Forum Discussion
Two slicers on one table, strange dropdown list behavior
Community ChampionFrom the pictures it looks like your model slicer isnt working at all. What happens if you remove the brand slicer and then change the filter around abit on the model slicer?
/J
Hi tex628,
Thanks for your reply.
Done as you said. The old item B1M2 is still there even all B2 and B3 models are listed. Unless I select other model, the B1M2 will disappear immediately and the dropdown list back to normal.
However, the new selected model will be a member of the models of next selected brand.
After
- tex628
From what i can tell your model filter actually works as intended. The reason for the weird behaviour is that you have brand as a visual level filter inside the model slicer. Is there any reason for that?
That filter is there by default. Even I intentionally removed it, the behavior insists.
- tex628
I apologize, i read through the posts again and I realize that I didn't quite understand your concern.
I agree with you that this is kind of weird behaviour but honestly I think it's intended. If you don't want the possibility of this happening you need to make sure that both tables filter eachother. Add a double sided relationship between the two tables.
I don't think there is any way currently to change the selection in one slicer by changing another, even if the two selections contradict eachother.
/J