Forum Discussion
Two slicers on one table, strange dropdown list behavior
That filter is there by default. Even I intentionally removed it, the behavior insists.
Community ChampionI 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
Maybe 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.
- tex628
This is really weird. If both columns are in the same table "B2" should not appear in the brand slicer if you have B1M2 selected. Which means that you should not be able to change the selection away from B1 untill you have cleared your model slicer.
There is something wrong here because this is not the way it's supposed to behave.B2 appearing because 'model' slicer does not have filter effect on 'brand' slicer. The user does not want it.
The weird point is B1M2 should not remain in model dropdown list after the user switches from B1 to B2 in the brand slicer.