I found the solution to this problem online of using a slicer and having the months in order rather than alphabetically. The solution being sorting a column with the monthID . It works if I use the month ID in all my tables but my month table as sort by column is greyed out. Any suggestions.
Solved! Go to Solution.