As a Power BI report creator, I would like a date filter that the end user can change to the beginning of where my data starts (even if years ago), but would most likely use it for the past seven days AND forward up to seven days.
If the date is set for today and shows the past 7 days (or any one/multiple of those past 7 days) and forward 7 days (projected orders), I want Today to automatically change each day to Today and not be set to the date the report was published.
The end user also wants to be able to choose X (two) days ago, but NOT include yesterday (only one day's worth of data) and go in the future.
This will allow for the ability to select a range of days or certain days to help the end user understand data better.
This will allow the end user to see all data if they like, but he ability to see on