How to sort horizontal axis labels in a SSRS chart

Question

I have a bar chart as below

the horizontal axis has months and years,is there any way i can sort the months order? like January,february,March...

thanks in advance

Answer 1

Sort by the month number but display the month name:

SELECT Month(DateField) AS [Month], DateName(Month, DateField) AS [MonthName], OtherFields
FROM MyTable
ORDER BY Month(DateField)

Answer 2

you can use this DATEPART(m, table.date) AS MonthNumber, and you can sort it using this field, and add more sort field on the top for years using this DATEPART(yyyy, table.date) AS AccountYear.