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