Forum Discussion

Icon for Responsive Resident rank

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

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.

4 Replies

KNP
Super 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
  Responsive Resident
  5 years ago
  Hi Knp,
  
  I don't have month number. Please see snap shot below:
  
  Thanks
  - 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].