Forum Discussion

Erin's avatar
Erin
Helper I
9 years ago

Interaction between two Slicers doesn't work well

Hi All,   I have two slicers(S1 and S2) with some visuals on one report , S1(City) and S2(Product), and S1 can control S2 but S2 can't control S1. S1 and S2 can control all other visauls. The inter...
Need Help
v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

Erin

 

I‘ve got the response from Power BI team. This is by design.

We store previous selections and show them regardless of whether another filter may hide them. We do not want to clear selections based on filter from other slicers, and we are obligated to show any seleted items.

 

Best Regards,

Herbert

Erin's avatar
Erin
Helper I
9 years ago

v-haibl-msft

 

Could the team explain to us why this is by design? By my understanding, if the selection on higher level filter is unseleted, it means the user no longer needs data under that selection hierarchy, and also means the previous selection on lower level filter is not longer needed too.

 

Thanks

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    Erin

     

    Please refer to my last post for the explanation from PBI team. In this scenario, unselecting on higher level filter should make the previous selection on lower level filter unselected generally. But PBI now stores previous selections and show them regardless of whether another filter may hide them. The team do not want to clear selections based on filter from other slicers, and they are obligated to show any selected items.

     

    Best Regards,

    Herbert

    • Erin's avatar
      Erin
      Helper I
      9 years ago

      Any use cases they use to support this design?

      • Sean's avatar
        Sean
        Community Champion
        9 years ago

        Erin If you remember I was with you on this!

         

        First the bad news! :smileysad:

        I think this is more about the principle - you have selected something in the slicers yourself!

        Basically you have set the search criteria yourself!

        They are not about to undo/clear YOUR selections!

        As you can see in the picture you selected Dallas P1 and Houston P1

        They don't want to clear your selections - you are the only one that can clear them!

        In your example I guess the products are exclusive to those cities and its easier to see why you may not like the outcome.

        Hope this makes sense!

        If you have not selected something yourself and it does not apply it will disappear

        however if you have selected something yourself it will show no matter what because YOU selected it yourself!

         

         

        And now the good news! :smileyhappy:

        I think I may have found a solution for you =>the Hierarchy Slicer

         

         

        Hope this helps! :smileyhappy:

  • sanjayshah's avatar
    sanjayshah
    Advocate I
    9 years ago

    This clearly seems to be a bug. Request the PBI team to explain why it is "by design"...? Generally slicer values from the same table are dependent on selections. Lets say that a table contains both countries and cities. If i select a country, i see only the cities pertaining to that. Now if i select another country, it should show cities of the new country, it should not continue showing the city of the previous country !!

     

     

    Sanjay Shah

    Prosys, Pune, India

    • sanjayshah's avatar
      sanjayshah
      Advocate I
      9 years ago

      Hi Qiuyun :

       

      Thanks for your reply.

       

      Sorry, but I don’t agree with you. Let say that I have selected Year 2016, Quarter 1 and the Month slicer shows Jan, Feb and March. I have now selected March and the dashboard is showing the required numbers. Now if I select Quarter 2, do you mean that April, May and June along with March will be shown ?

       

      This may not be a “technical” bug, but seems to be a usability bug.

       

      Regards

       

      Sanjay