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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
gianmarco
Helper IV
Helper IV

Advanced filter

Dear All,

I can slice a table for the following row values:

0

1

2

3

 

What I want to achieve is a slicer where I can filter for the following options:

0 & 1,

0 & 2,

0 & 3.

 

In other words, you can slice for 1, 2 & 3 only but when you do you always slice for 0 as well.

 

Thank you very much

gianmarco

 

 

 

1 REPLY 1
lbendlin
Super User
Super User

0 & 1

That's not what you mean, you need 0 || 1  (or, not and).

 

Usually this is achieved by UNIONing two tables, one static (with the 0) and one to feed the slicer (1,2,3).  The UNION needs to be done inside a measure and that measure needs to produce a 1/0 value that can be used as a visual filter.

Helpful resources

Announcements
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
Top Kudoed Authors