Forum Discussion

sdhn's avatar
sdhn
Icon for Responsive Resident rankResponsive 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.

KNP's avatar
KNP
Icon for Super User rankSuper User
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
    Icon for Responsive Resident rankResponsive Resident
    5 years ago

    Hi Knp,

     

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

     

     

    Thanks 

     

    • KNP's avatar
      KNP
      Icon for Super User rankSuper 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
        Icon for Responsive Resident rankResponsive Resident
        5 years ago

        Thanks