- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 Slicers working together to Filter data
Hello, This is a simplistic version of a problem I’m having. I want to be able to click “Apple” button and it shows all the locations that have both existing and ordered apples (and the same for Bananas with the “Banana” button).
I would like to then click the “Existing” button with the “Apple” button being selected and it only shows locations that have a value greater than zero for Apples Existing. Then I’d like to do the same by unselecting the “Apple” button and selecting the “Banana” button with the “Existing” button still selected to see only locations with existing bananas greater than zero.
I had a work around where I created specific slicer buttons for Apples existing and Banana’s existing but I was hoping to use this setup with only three slicers that worked together. I ended up with too many separate buttons when I added the “Ordered” button’s for each and I want as few buttons as possible. I don’t know how to get it to filter out the existing apples that are zeros when “Apples” is selected with “Existing” and then the same thing with “Bananas” and “Existing” both selected.
Apple: Shows all instances of Apples (both existing and ordered)
Banana: Shows all instances of Banana (both existing and ordered)
Existing: Shows all instances that have an existing value (both apple and banana)
The endgame is to use these slicers to filter locations on a map visual. So if I wanted to see only the locations that have existing apples I would click those 2 slicers.
Thanks in advance!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you use the filter pane instead you can have one "OR" condition per column. That should suffice in your scenario.

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
56 | |
55 | |
54 | |
37 | |
29 |
User | Count |
---|---|
77 | |
62 | |
45 | |
40 | |
40 |