Filter a visual on or before today's date

[pigsinblankets]

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! 

Thanks 

[mlsx4 · Accepted solution]

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 · Accepted solution]

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 👍

[pigsinblankets]

Thank you @DOLEARY85 🙂

[mlsx4 · Accepted solution]

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) 

[pigsinblankets]

Ahh thank you @mlsx4 🙂