Last 12 Months (LTM) Dates Out of Order

[Anonymous]

Hi,

I am using a line and clustered column chart and I want to display the last 12 months of the values I am analysing. I have set the date filter to show the relative date in the last 1 years within the filter column, whereby the dates assessed are saying the correct dates (07/05/21 - 06/05/22) and the chart below is showing the correct values for those months, but they are out of order. This graph is showing Jan-Apr 2022 with the following columns being May-Dec 2021. 

If DAX is needed, my date variable is 'Proposal Sent Date', with the column y-axis as 'Gross Value' and line y-axis is 'count of Gross Value', thanks!

[tamerj1 · Accepted solution]

Hi @Anonymous 
If you don't want to use a date table then you need create a Month Number and Month Name columns
Month Number = MONTH ( Table[Date] )
Month Name = FORMAT ( DATE ( 1, MONTH ( Table[Date] ), 1 ), "MMMM" )
You can use the "Sort By" the sort the month name based on month number.
You can also create a date hierarchy as shown in the following screenshot