Forum Discussion
Two slicers on one table, strange dropdown list behavior
Hi all,
Scenario: 1 data table (sales by brand and model), 2 slicers, slicer 1 (brand) has a filter effect on slicer 2 (model).
It is found that after an item has been selected on slicer 2, changing the selected item on slicer 1 does not remove it but mixes it with items of current selected slicer 1.
E.g. B1 of the brand slicer is selected and B1M1 model slicer is selected. Then select B2 of brand. List of model should now contain only models of B2 (like B2M1, B2M2). However, the dropdown list of model slicer contains B1M1 mixed with B2 models and it is the default value. See screen capture below.
It seems it is a bug of dropdown list of built-in slicer.
Any comment is appreciated.
Thanks in advance
James
9 Replies
- tex628
Community Champion
From 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?
/JHi 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?
