Forum Discussion

tiny's avatar
tiny
Frequent Visitor
2 years ago
Solved

Interaction doesn't refresh on another slicer when a slicer selection changes

Hello,

 

I need to ensure Single selection for hierarchy on Slicer, but it looks like Power BI doesn't support it after I did some search on the web. So I tried to implement a workaround by seperating hierarchy as three slicers. And I make sure the interaction is correctly played as hierarchy. But the problem is when I select a different value from higher level, the next level refreshes with the new values, but keep the last selected value. Here is an example: suppose we have a location table:

with three slicers:

we selected CN, then ON, then NORTH YORK, but if we changed to select US, we got the following:

We can see the dropdown list are refreshed accordingly, but the selected value still old values, how can we get rid of the old value when the dropdown list is refreshed? 

 

Your help is really appreciated!

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi tiny 

    Thanks for your quick reply , you can consider to use new slicer, it support the clear icon when you use single selection. and when you click other seleciton , the original selection will disappear.

     

    If you don't have the new slicer, please update your desktop version to the newest.

     

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

6 Replies

  • adudani's avatar
    adudani
    Icon for Memorable Member rankMemorable Member
    2 years ago

    hi tiny ,
    You should be able to add a hierarchy/three fields into the same slicer choose single select shown below:

     


    if this doesn't resolve the issue, kindly provide a sample input and output data masking sensitive information

    • tiny's avatar
      tiny
      Frequent Visitor
      2 years ago

      Thank you so much Avinash for quick reply. The problem is we want to ensure the single selection on the leaf level. Your example has two values selected under Korea. We would like to allow only one selected at the last level....

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi,

        Thanks for the solution adudani  provided, and i want to offer some more information for user to refer to.

        hello tiny , based on your description, This is related to the Power BI design, if you want to remove this option, before you check the other options, you will need to click the clear icon in the top right first then this option will disappear and you can select other options.

         

        Best Regards!

        Yolo Zhu

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.