Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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?
Name | Number | |
Name 1 | 1 | |
Name 2 | 2 |
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.
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