Forum Discussion
Date Slicer default value
Please see the relative date slicer/filter functionality. You can set the slicer (or filter in filter panel) to filter to the last X days.
Use a relative date slicer or filter in Power BI - Power BI | Microsoft Docs
Pat
Hi acmo ,
I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting.
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_ Binbin Yu
We have a report with a temporary window, for example from August 4th to August 20th.
In order to filter by dates, we use the default component of power bi with the calendar functionality:
The data in the report is updated automatically every day, so, on August 21st we will have the data for the August 20th available (our time window increases).
Whenever we open the report, by default, we want to display data from the last available day (without having to filter manually).
In summary, we want, that when we open the report on the August 21st, to automatically see the data for August 20th, when opening the report on August 27th, see the data for August 26th and so on but
taking into account that the functionality of being able to manually filter a time window (for example from January 30th to February 13th) must still work.
Kind regards.
Please see the relative date slicer/filter functionality. You can set the slicer (or filter in filter panel) to filter to the last X days.
Use a relative date slicer or filter in Power BI - Power BI | Microsoft Docs
Pat