Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date filter

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

 

 

 

  • PaulOlding's avatar
    PaulOlding
    5 years ago

    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'

     

2 Replies

  • PaulOlding's avatar
    PaulOlding
    Icon for Solution Sage rankSolution Sage
    5 years ago

    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'

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.