Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Dynamic date filter

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 !

"Power BI"
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

     

    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!

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous ,

     

    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!