Forum Discussion
Date filter starting from today
tips
Hi,
is it possible to publish a report with a "dynamic" date filter ?
I mean, if i open the report today it will automatically filter from "17/02/2020" until the last data.... without moving the filter
- Anonymous6 years ago
Hi Anonymous ,
Then you can try use Relative date filter as Agherardi mentioned above.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- AnonymousNot applicable
You can add a date filter on the page (or all pages) that is a relative date filtering type and goes like "date is in the last 30 years" and it will automatically filter the date filter up to today
If you want a more elegant solution, check out this post instead:*
https://community.powerbi.com/t5/Desktop/Power-Query-Current-Date-Filter/td-p/67586 - AnonymousNot applicable
Hi Anonymous ,
Try create a measure as below and add it to the filter.
Measure = IF(SELECTEDVALUE('Table'[date])=TODAY(),1,BLANK())Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
Hi Anonymous ,
Have your problem be solved? Please consider accept the answer as a solution if it worked.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
Hi,
without using a measure is not possible?
I open the report today and it's filtered starting from today, without clicking filter or sth else
Thanks