Forum Discussion

anelliaf's avatar
anelliaf
Icon for Helper II rankHelper II
1 year ago
Solved

Slicer - Reset Selection when choosing new one

Hello,

 

I have a drop-down slicer where if a selection is made, the list of values is shown in a table.  In that table are radio buttons to select a value.  However, when a new selection is made in the slicer, the remaining selected value still shows in the table along with the new values from the current slicer selection.

 

How do we setup the slicer or relationship to reset the old values so they are not shown with the new selection?

  • Hi anelliaf 
    If you need the slicer to allow select just 1 value each time you can switch on this option:

    The second option is to guide the users to use a small "eraser" button to clear selections if you need to allow multiple selections :

    You can also add a clear all slicers button , but note that it will clean the all slicers selections and not just the selections of the current slicer

    The pbix with the examples is attached

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

     

2 Replies

  • Hi anelliaf , Resetting the slicers automatically based on another slicer selection is not currently possible. But you can achieve it manually by simply adding an inbuilt Clear All Slicers button. So that the user can click this button to clear all the previous slicer values and apply next slicer values.

    You can find this button under Insert->Buttons->Clear All Slicers 

     

    Did I answer you question ? If yes, please mark my post as a solution.

     

    Thanks,

    Jai 🙂

  • Hi anelliaf 
    If you need the slicer to allow select just 1 value each time you can switch on this option:

    The second option is to guide the users to use a small "eraser" button to clear selections if you need to allow multiple selections :

    You can also add a clear all slicers button , but note that it will clean the all slicers selections and not just the selections of the current slicer

    The pbix with the examples is attached

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