Compare dates in dashboard with both start dates being fixed

[stephaniej71500]

I have a dashboard that I would like to do a TY/LY comparison with, and I would like the start date for both ranges to be fixed (3/6/15-rolling date and 3/4/16-rolling date). However, I seem to only get the option to choose fixed or rolling for my first set of dates (LY in this case, see screenshot attached). My other set of dates (TY in this case), just seems to constantly roll. When I originally set up the dashboard, we were only a week into the time period (7 days). So now, my dates show 3/6/15-3/19/15 (this is correct) compared to 3/11/16-3/17/16 (last 7 days, incorrect because I wanted the first date to hold at 3/4/16). Is there a way to remedy this without have to resort to using report builder instead?

[David_Goodes · Accepted solution]

Hi - have you looked at Analysis Workspace for this? There you can create a number of date ranges and save them for example

Start date: Start of this week minus 53 weeks

End date is: End of this week minus 53 weeks

They have some prebuilt ones such as 'last' week and 'two weeks ago' too, to get you started.