I want to display a bar chart with Trailing 12 months (TTM) using a Relative Date slicer with Last 12 months. The issue is that my last 12 months don't sort correctly. If we're in Sept 2018, I'd like the the first bar to be Oct 2017, then Nov 2017, and go all the way to Sept 2018. But it doesn't happen like that as the bars sort alphabetically or by month number (I have a column month number also).
I also tried to Sort by 'Month number overall' which I also have in my table. But it throws an error because my Month Names have more than one Month Number Overall. That is, Jan is 171, and also 183, and 195 etc.
I'm looking for an easy solution using the Relative Date Slicer. Please advise.
This is what you should be doing
Hope this helps.
Thanks for your response. Unformtunately, this does not produce the desired results. This will sort the months as Jan, Feb, Mar........., Nov, Dec.
I wish to sort them based on last 12 months from the current month. So if we're in Sept 2018, I would like the chart to display 12 bars, starting left to right from Sept 2017, Oct 2017, Nov, 2017..........Jun 2018, Jul 2018, Aug 2018. Thanks.