Sorting MonthName

[mahitham]

Hi,

Can any one please help me on below issue.

How to sort MonthName from January  to December in Slicer.

Thanks in advance.

[Zubair_Muhammad · Accepted solution]

@mahitham

Hi,

You can a calculated column to get month numbers

Then sort the Month Name column by Month Number column

Month_Number =
SWITCH (
    [MONTH_Name],
    "August", 08,
    "December", 12,
    "July", 07,
    "November", 11,
    "October", 10,
    "September", 09,
    "April", 04,
    "February", 02,
    "January", 01,
    "March", 03,
    "May", 05,
    "June", 06
)

Check this post as well

http://www.excelnaccess.com/custom-sorting-in-power-bi/