Month Name (with Quarter / Month Hierarchy) not in order

[JustDavid]

Been trying many ways to resolve this but I can't seem to fix the month for just 1 quarter.

Note that I have tried sorting it by 'Month' by selecting the 'Month Name'.

           

[JustDavid]

@jgeddes  Thank you! I have a column that is called 'Fiscal Period' which is exactly the same as your "Month in Fiscal Year' where "Dec" is fiscal period 7 and "May" is fiscal period 12. Sorting my "Month Name" with "Fiscal Period" solved it.

[jgeddes · Accepted solution]

You may want to consider creating a calculated column in your date table called "Month In Fiscal Year" and assigning the month number to each month name. In your example above "Dec" would be month 7, "May" would be month 12. Then Month Name sort by column to the new Month in Fiscal Year column.