Forum Discussion

Roym's avatar
Roym
Helper IV
2 years ago

Slicer also include previous value in selection

I have a table with basicly the columns name, year, and a number based on the year starting from 2021 = 1, 2022 = 2 etc. 

Now I have a slicer that shows the names and that is used to filter a couple of other visuals. What I would like to do now is that if you select the name it also includes the previous one in the visuals for example if in the slicer I would select  Name 1 (number = 1). It will also show/select 'Name 2 (number =2). Any idea how I can achieve this?

 

NameNumber 
Name 11 
Name 22 
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Roym ,
    According to your description, you want to display the previously selected options together in the visual object of the latest application slicer. However, Power BI does not “remember” the status of user-selected filters. This information is not stored anywhere and is lost when the filter status changes.
    If you want to display more than one piece of data in a visual object, you can turn on the Multiselect option in the slicer settings so that you can Ctrl+click to make multiple selections

     

    Best regards,
    Albert He

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

     

  • Roym's avatar
    Roym
    Helper IV
    2 years ago

    Thanks, but what I'm trying to achieve is a bit different. It should not remember the previous selection but if someone selects number 2 in the slicer it should automaticly include 1 as well. So in every case it should also select one number lower as well so by making one selection you automaticly get two selected.