Forum Discussion

tainguyen's avatar
tainguyen
Frequent Visitor
8 years ago
Solved

Sorting Slicer to Month

Hi guys,   I have having difficulties sorting the month in my slicer. Above is how it looks on the report.   Below is the data, i tried to change the data type to date but i get an error. ...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Since you already have your month numbers, this will be very easy for you.

     

    Select your Month column, then select the Modeling tab at the top ribbon, then use the "Sort by Column" option to select the MonthNo column. This is happening because a text field will sort itself alphabetically by default, but you can instruct that column to sort by the numbers in your MonthNo column.

     

    EDIT:

     

    Here's a quick demonstration:

     

    default sorts the first column alphabetically

    "Sort by Column" selection on Rank

    Now default sort for the first column is by the associated rank