Forum Discussion

pigsinblankets's avatar
pigsinblankets
Icon for Helper II rankHelper II
2 years ago
Solved

Filter a visual on or before today's date

Good Afternoon,    Is there an easy way using the filters pane to filter visuals on or before today's date?    I can't seem to see this as an option which seems a bit odd unless I'm missing it!  ...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • mlsx4's avatar
    mlsx4
    2 years ago

    Hi pigsinblankets 

     

    If you have a calendar table, you can create an offset column which returns -1 if it's before today's date or 0 otherwise. Then, you can use filter pane to filter by <0 values

    Offset = IF('Calendar'[Dates]<=TODAY(),-1,0)
  • DOLEARY85's avatar
    DOLEARY85
    2 years ago

    Hi,

     

    You could created a field in power query that flags all dates from today and use that on in the filter pane:

     

    Power query column: if [Date] >= Date.From(DateTime.LocalNow()) then 1 else 0 

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
2 years ago

Hi pigsinblankets 

 

If you have a calendar table, you can create an offset column which returns -1 if it's before today's date or 0 otherwise. Then, you can use filter pane to filter by <0 values

Offset = IF('Calendar'[Dates]<=TODAY(),-1,0)