Forum Discussion

Rich2852's avatar
Rich2852
Frequent Visitor
7 years ago
Solved

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 d...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

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

     

     

    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)

     

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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

 

 

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)

 

 

Best Regards

Maggie