Filter with two dates

Yes, this is possible, but it can’t be done with a standard date slicer alone because slicers work on one date column at a time. You need to model the logic explicitly.

Use one Date table and check whether the selected date range overlaps your Start/End dates.

1) Create / use a Date table

Mark it as a Date table.

2) Create a measure

In Date Range =
VAR MinSelDate = MIN ( 'Date'[Date] )
VAR MaxSelDate = MAX ( 'Date'[Date] )
RETURN
IF (
    MAX ( Fact[StartDate] ) <= MaxSelDate
        && MAX ( Fact[EndDate] ) >= MinSelDate,
    1,
    0
)

3) Use it

• Put 'Date'[Date] on a Between slicer

• Add In Date Range = 1 as a visual-level filter

This keeps rows where the date interval overlaps the slicer selection.

Hi,

See if my solution in the attached file helps.

Hi FilipaPereira ,

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.

Thank you.