Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Child filter doesn't update based on the parent filter selection

Hi All,


I have a dataset sample that looks like this: 

Sales ModelDealerMachines
DieselD256
DieselD556
DieselD867
LPGL367
LPGL677
LPGL943
PetrolP154
PetrolP435
PetrolP754


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's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity 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.

    • Anonymous's avatar
      Anonymous
      Not 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.