Dynamic date filter

[TomerIwanir1]

Hi All,

I'm using Slicer visual in order to slice and dice dates :

I want to set the filter to  auto update daily to show the dates of: (Today - 7) until (today - 1)

what should I set in the filter section:

Thanks !

[Anonymous · Accepted solution]

Hi @TomerIwanir1 ,

Thanks for the reply from lbendlin .

Create a measure to determine the range:

IsInRange = 
VAR TodayDate = TODAY()
RETURN
IF(
    MAX('Table'[Date]) >= TodayDate - 7 && MAX('Table'[Date]) < TodayDate,
    1,
    0
)

Drag IsInRange into the Filter and set the condition to IsInRange = 1.

The final visual effect is shown below:

The pbix file is attached.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[lbendlin]

Use the "Relative Dates"  filter type instead, and choose "In the last 7 days".