Month Sorting in Slicer/Filter (PowerBI)

Question

I created a year hierarchy to be used in a slicer/filter (as shown below)

Pic 1

However, when i put the "Month" into the slicer, it sorts in alphabetical order instead of from Jan-Dec (as shown below)

Pic 2

How can i solve this issue?

Answer 1

You need to create a new column in your Date table. Something like:

MonthNum = MONTH([Date])

Then select your Month column, under Column tools tab in the ribbon, select Sort by column and select the new column you just created (MonthNum).