Changing order of dates in line chart

[Noah Holihan]

Hi all,

I have a set of data that I would like to compare monthly totals on a monthly basis, over each year. For instance, I have data for the previous two years and I would like to compare January to January and so on. However, when I overlapped the lines by changing the X axis to BinByDateTime( [Timestamp], "Month.Year",0), the axis automatically changed from having the last month as the current month to starting from January and ending in December. How do I keep the same formatting where I have the lines of each year seperate and overlapping, while changing this axis back to ending at the current month Any help would be much appreciated.

 

Thanks,

Noah