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
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