Forum Discussion
Child filter doesn't update based on the parent filter selection
Hi All,
I have a dataset sample that looks like this:
| Sales Model | Dealer | Machines |
| Diesel | D2 | 56 |
| Diesel | D5 | 56 |
| Diesel | D8 | 67 |
| LPG | L3 | 67 |
| LPG | L6 | 77 |
| LPG | L9 | 43 |
| Petrol | P1 | 54 |
| Petrol | P4 | 35 |
| Petrol | P7 | 54 |
Using this dataset I created 2 filters called Sales Model and Dealer and 1 KPI called Machine Count which would update based on Sales model and Dealer selection.
Both filters are single select.
Dealer is child filter such that is if Petrol sales model is selected only petrol dealers will show up
Therefore dealer filter, I Edited the interaction (using Edit Interaction in Format Menu) such that dealer filter should not affect values of sales model filter.
Now when I change the sales model filter to any other value.
I expect that the change in the sales model should automatically change the dealer to a default top value in its category. Rather the dealer filter retains the old value that was last selected.
Here is the link to the Report
2 Replies
- v-yuta-msft
Community Support
Anonymous ,
Change the slicer type to "list", then when you select another selection in Sales Model slicer then last selected value will not appear in the Dealer slicer.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
Hi,
Thanks for the reply. But the client doesn't want me to change it to dropdown as that filter in real has more than 15 values for each sales model.