Forum Discussion
Two slicers on one table, strange dropdown list behavior
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
Community ChampionFrom 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.
/JMaybe I am not presenting well. There is only 1 table. Therefore, I'm not able to use relationship.
There is no need for the 2 slicers to filter each other. Instead, the user wants the 'brand' model slicer always show all available brands with the 'model' slicer shows only items corresponding to the selected brand.
From PBI Desktop filter pane, we can see that the model slicer shows correctly all available items. It is only the problem of the model slicer dropdown list visual object showing a model that belongs to the previously selected brand. Non-dropdown list visual does not have this weird behavior.
It happens when user selects a new brand after selecting a model of the previously selected brand.
The only way to get rid of the incorrectly shown model is by selecting a model corresponding to current selected brand. However, it is not feasible to tell user do this each time he/she switches to another brand.