2 Slicers working together to Filter data

[KWC137]

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!

[lbendlin]

If you use the filter pane instead you can have one "OR"  condition per column. That should suffice in your scenario.