Reply
Highlighted
Regular Visitor
Posts: 21
Registered: ‎07-30-2018
Accepted Solution

Sorting MonthName

Hi,

 

Can any one please help me on below issue.

How to sort MonthName from January  to December in Slicer.

 

MonthName.png

 

Thanks in advance.


Accepted Solutions
Super User
Posts: 2,833
Registered: ‎09-27-2017

Re: Sorting MonthName

[ Edited ]

@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/

View solution in original post


All Replies
Super User
Posts: 2,833
Registered: ‎09-27-2017

Re: Sorting MonthName

[ Edited ]

@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/