Date filter

[Anonymous]

I have date fields like below, in this date visual how can i restrict the from and to date. From date is a standard one(say 2021-05-25) and to date is getdate. Thanks

[Anonymous]

Add a column to your date table with 1 for the dates you want to see and 0 for the others. Then filter by this field (the slicer can be hidden if you don't need to show it). Your dates will adjust automagically. Or you can create a helper measure that will use such a column (which you can hide) and use it to filter the entries of the slicer via the Filter Pane.

[PaulOlding · Accepted solution]

You could add a measure to use in the visual level filter.

Display Date =

VAR _CurrentDate = MAX('Date'[Date])

VAR _Result = IF(_CurrentDate >= DATE(2021, 5, 25) && _CurrentDate <= TODAY() , 1, BLANK())

RETURN

_Result

then set the filter to 'is 1'