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 ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I tried your solution, adding a column "Filtre mois" : 

    =if(SecuriteAuTravail[Dernier_mois_dispo]=SecuriteAuTravail[mois_x] ;"Dernier mois disponible";SecuriteAuTravail[Mois])

     

    So, if the month is the last month available, it displays "Dernier mois disponible", if not, it displays the month name.

    It works fine in the report, when refreshing with new data loaded, it keeps it ticked on "Dernier mois disponible".

     

    The problem is when I change the year selected in the report, the month of March for example which is the last month loaded in 2020 is still name "Dernier mois disponible" in 2019, it is not possible to keep it like this 😞

    I tried adding the year in the condition of my formula : 

    =if(SecuriteAuTravail[Dernier_mois_dispo]=SecuriteAuTravail[mois_x] && SecuriteAuTravail[derniere_annee_dispo]=SecuriteAuTravail[Annee];"Dernier mois disponible";SecuriteAuTravail[Mois])

     

    But doing like this, it displays March + Dernier mois disponible as 2 different months in the filter, so not ok neither...

    If you have an idea, I will be glad 😉

     

    THanks a lot, AnSo