Would this work?
I created a separate calculation for those last three months and the put them as dual axis.
Hope it helps, if does please mark it as correct so other users can refer to it. Thank you!
Example Sindhu.twbx 2.2 MB
I am not able to open
can you resend the twbx file save in lower version or , can you send the calculated field logic for last 3 months.
Thank you so much in advance!!
Hope this one works!
The Calculation is:
IF DATEPART("month",[Order Date])>(DATEDIFF("month",[Order Date],TODAY())+5)
In your case would be "-3" instead of "+5" because i'm using an old dataset that does not correspond with the current date.
I used TODAY to make it dynamic, but you can just put another ending date if you prefer.
Then use that formula in a dual axis with your date field and synchronize the axes.
Afterwords, change your mark cards of the "Last three months" to circle instead of lines.
Hope this helps!
Example Sindhu_v10.2.twbx 2.2 MB