Aligning Alternate State trend lines in Line chart
I have two alternate states showing two different products.
The end user wants to select a date range for product A and a date range for product B.
The date range chosen is different for each alternate state BUT the user wants it to appear running parallel with each other. So in the image below, they would like Product B to start at the same position as Product A regardless of the date chosen. (I know this obviously undermines the value of having a date dimension field).
The only way I can think of doing this is to manipulate the date dimension and create a numerical month (e.g. month1, month 2, month 3 etc) to compare the two. This would then enable the comparative trend lines to appear together. Is this possible ?