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

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

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?