Forum Discussion

thorpyuk's avatar
thorpyuk
Helper III
6 years ago

Reset one slicer when changing another

Hi, is it possible to have one slicer 'clear selections' on another when a different selection is made?   EG, if i have a slicer with a choice of 'cars' or 'motorbikes', and then a 2nd slicer with ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Radhika

 

Thanks a lot for the tip. Much appreciated!

 

However, the issue still remains: the selection on the 2nd slicer does move according to the selection on the first slicer. However, the selection in the 2nd slicer does not default to the top element in that 2nd slicer. This is the functionality that I need.

 

Thanks again

BernardNie

Radhika2605's avatar
Radhika2605
Helper II
5 years ago

Hi Anonymous 

 

Could you please clarify a bit more, may be using an example please?

 

Thanks

Radhika

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Radhika

     

    I have the following (very simple) dataset

    • Table 'Countries' with the field [Country]
    • Table 'Sales' with the fields [Country], [Quarter], [Sales]
    • One to Many relationship between the tables

     

    Slicers:

    • One on 'Countries'[Country]
    • One on 'Sales'[Quarter]

     

    Step 1: Select a Country = "Australia"

    • The 2nd slicer shows the Quarter
    • Select the Quarter 2
    • Everything is working well

     

    Step 2: Select the Country = "UK"

    • The slicer for the Quarter stays on Quarter 2
    • The required behaviour is for the slicer on the Quarter to move to the top again automatically  (to Quarter 1)

    So, every time a Country is changed, the Quarter filter must reset to Quarter 1.

     

    Any ideas?

     

    Thanks a lot!

    BernardNie