Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Post Prodigy
6 years ago
Solved

Date Filter: default to current day?

Is there anyway to set a date filter to default to current day, or X days ago, etc?   I've tried doing relative date last week or is today, etc... but all that does it limit the values available to...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    I know this problem.
    I create a column where i renamed the actual day as "Actual day", to set the default filter on it.

     

    DateFilter = IF('Date'[Date]=TODAY(),"Actual day",FORMAT('Date'[Date],"dd.MM.yyyy"))
     
     
    Please give Kudos for support.
    If I answered your question, please mark my post as solution, this will also help others.
mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

I know this problem.
I create a column where i renamed the actual day as "Actual day", to set the default filter on it.

 

DateFilter = IF('Date'[Date]=TODAY(),"Actual day",FORMAT('Date'[Date],"dd.MM.yyyy"))
 
 
Please give Kudos for support.
If I answered your question, please mark my post as solution, this will also help others.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi mwegener, 

 

I will try your solution but reading it I am wondering what you mean by "put the default filter on the current date".

Because if I add a filter on the "actual day" in the filter pane, I won't be able to change the period selection anymore in the report, will I ?