Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 select.
The value the report was last saved under is always the value selected on load.
For example I published a report Feb 18th. Now, every time the page loads, it always has Feb 18th selected, regardless of how I set the relative date filter options.
Solved! Go to Solution.
I know this problem.
I create a column where i renamed the actual day as "Actual day", to set the default filter on it.
I know this problem.
I create a column where i renamed the actual day as "Actual day", to set the default filter on it.
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
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 ?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |