Create a calculated field as latest date:
then create another date filter as :
[Start Date]>=DATEADD('month',-7,[latest date]) and [Start Date] <= [latest date]
and put this on filter shelf and choose TRUE. Attached is twbx.
Book1_v10.5.twbx 493.6 KB
Sorry, I think I was not clear what I wanted.
Please see the screenshot below.
1. When I open the dashboard, by default, June-2018 should be selected which is the latest date
2. Then the graph should be plotted for last 8 months including June-2018. Thus, we see 8 bars in chart as shown below
Attached updated .twbx
Book1.twbx 471.2 KB