Reply
KWC137
New Member

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).

KWC137_0-1695169317683.png

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. 

KWC137_1-1695169363472.pngKWC137_2-1695169377707.png

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!

1 REPLY 1
lbendlin
Super User
Super User

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

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

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.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)