Forum Discussion

sdhn's avatar
sdhn
Responsive Resident
5 years ago
Solved

Sorting month on slicer

Hi All,   I am struggling with how to sort the slilcer the way I need:    I want as below:   Feb  Mar Aprl May   But it is showing as: April Feb Mar May   Thanks     
Need Help
  • KNP's avatar
    KNP
    5 years ago

    Hi sdhn,

     

    You need the month number in your table to sort by. Once you have that, select the text month column and choose sort by, then select Month Number.

     

     

    Hope this helps.

sdhn's avatar
sdhn
Responsive Resident
5 years ago

Hi Knp,

 

I don't have month number. Please see snap shot below:

 

 

Thanks 

 

KNP's avatar
KNP
Super User
5 years ago

You'll need to add one. 

There are a few different ways to do this, in DAX, choose new column and enter this...

Month Number = MONTH(DATEVALUE(2021 & "/" & 'Date'[Month] & "/" & 1))

 

You'll need to rename the 'Date'[Month] to match your 'Table'[Column].

 

 

  • sdhn's avatar
    sdhn
    Responsive Resident
    5 years ago

    Thanks