Reply
Frequent Visitor
Posts: 7
Registered: ‎06-13-2017
Accepted Solution

Apply an OR filter when using a slicer

I have a matrix table that I want to filter based on a date slicer on a set of customers. However, I have another field that if its null/blank I would like the filter to not touch regardless of the date on the filter. 

 

For example 

 

ID         Val               DateField

1            3                   2007-01-01

2            2                  2005-01-01

3            2                  2001-01-01

4                                1999-01-01

 

If I have a DateField slicer and I set it to  2004-12-31 I'd like the following results:

 

ID         Val               DateField

1            3                   2007-01-01

2            2                  2005-01-01

4                                1999-01-01

 

ID1 is selected because the DateField is greater than the selected date 

ID2 is selected because the DateField is greater than the selected date 

ID4 is selected not because the datefield is greater but because the Val field is blank.

 

I'm basically requiring an OR statement on the slicer. 

Any ideas?

 


Accepted Solutions
Community Support Team
Posts: 2,542
Registered: ‎03-15-2018

Re: Apply an OR filter when using a slicer

Hi @Rich2852

You could create a date table, then edit relationship with your data table, next add the "date" column to a slicer

Table = CALENDARAUTO()

4.png

 

 

2. create a measure in your data table, then add this measure to the Visula level filter and set "show data when value equal: 1".

Measure = IF(MAX([DateField])>SELECTEDVALUE('Table'[Date])||MAX([Val])=BLANK(),1,0)

3.png

 

 

Best Regards

Maggie

View solution in original post


All Replies
Community Support Team
Posts: 2,542
Registered: ‎03-15-2018

Re: Apply an OR filter when using a slicer

Hi @Rich2852

You could create a date table, then edit relationship with your data table, next add the "date" column to a slicer

Table = CALENDARAUTO()

4.png

 

 

2. create a measure in your data table, then add this measure to the Visula level filter and set "show data when value equal: 1".

Measure = IF(MAX([DateField])>SELECTEDVALUE('Table'[Date])||MAX([Val])=BLANK(),1,0)

3.png

 

 

Best Regards

Maggie