Date slicer to filter out blank Dates?

[Anonymous]

Hi all ,

I have a simple Events table as above and then just one other table

DateTable = CALENDARAUTO()

They are related one to many from DateTable to Events (single direction) on the date columns.

I am expecting my date slicer to run from 01/01/2000 to 031/12/2000 which it does.

But I am also expecting it to filter out the blank dateclosed row. When the slicer is set from 01/01/2000 to 31/12/2000 it does not as below.

Can I get it to remove the blank if 01/01/2000 is in the slicer start value?

Thanks - its correct if the slicer is set to start on 02/01/2000 (3 records)

[vivran22 · Accepted solution]

Hello @Anonymous ,

You may use the Filter option to and deselect Blank option from DateClosed field:

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn