Forum Discussion

figo12's avatar
figo12
Icon for Helper I rankHelper I
9 years ago
Solved

New October Date Slicer still cannot sort month names correctly on Charts

Hi, the new October Date Slicer is great but it cannot sort month names correctly on Charts if they are filtered as "monthly", month names appear in the incorrect order, is there a way to fix this? ...
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    Create a new column by right clicking your table and use the below DAX Formula

    MonthNo. = MONTH(YourTable[Date])

     

    Followed by this, Select the Month Name Column in the Datatab View, Go to the Modelling Tab and Choose Sort by Column, Select MonthNo..

     

    This will sort your month  names by the month no. . FYI- Default sorting is A-Z which makes month names sorting alphabetically.

     

    See the screenshot.

    SORT BY COLUMN

  • figo12's avatar
    figo12
    9 years ago

    It worked great!!! Thanks very much  BhaveshPatel

figo12's avatar
figo12
Icon for Helper I rankHelper I
9 years ago

Thanks BhaveshPatel, you mean the month column and also and ID number Column for each month?  Have not used the DAX solution before, if you have some steps it would be great. Thanks again!

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

Create a new column by right clicking your table and use the below DAX Formula

MonthNo. = MONTH(YourTable[Date])

 

Followed by this, Select the Month Name Column in the Datatab View, Go to the Modelling Tab and Choose Sort by Column, Select MonthNo..

 

This will sort your month  names by the month no. . FYI- Default sorting is A-Z which makes month names sorting alphabetically.

 

See the screenshot.

SORT BY COLUMN

  • figo12's avatar
    figo12
    Icon for Helper I rankHelper I
    9 years ago

    Thanks!! BhaveshPatel I will give it a try!

    • figo12's avatar
      figo12
      Icon for Helper I rankHelper I
      9 years ago

      It worked great!!! Thanks very much  BhaveshPatel

  • walterosLP's avatar
    walterosLP
    Frequent Visitor
    9 years ago

    Hi there,

    I am running in the same issue on PowerBI [November update], trying to sort month in a Slicer, drop-down list and even Weekdays from the same table.

    However, even I did sort them correctly, non of both lists does any sort at the report view and show it in a list by random.

    What can be wrong?