Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Roym
Helper IV
Helper IV

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 
2 REPLIES 2
Roym
Helper IV
Helper IV

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.

Anonymous
Not applicable

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

vheqmsft_0-1716341527713.png

 

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

 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors