Forum Discussion
Sorting Slicer to Month
- Anonymous8 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
Here is the table visual with the month without sorting.
:smileysad:
Ive fixed the problem!
I didnt set a data type for the MonthNo column. Stupid me
Thank you for your help!!
- swarnalakshmi8 years agoRegular Visitor
I have set the slicer to sort by month no and i have set the month number to Whole number data type still the sorting does not happen. Can you guys help. TIA Swarna