apply last 7 days and publish to server.
When you leave any value in filter that only avail once open workbook in server.
Thanks for the reply Rajan!
I have done the same, but it works only when anyone open the dashboard today (27 Jun). Let say if i open the dashboard tomorrow(28 Jun), the values still remain for 7 days till 27 Jun even after the data refresh.
You will need to use a relative date filter instead of the range filter and select the last 7 days.