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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register 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.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors