Forum Discussion
gra_197
Helper II
Helper IISlicer data
Hi, How can I get the above slicer to play ball, the months are all over the place. Many thanks
1) Create a Month Number column
In your Date table:
Month Number = MONTH ( 'Date'[Date] )2) Sort Month Name by Month Number
-
Select Month Name column
-
Column tools → Sort by column
-
Choose Month Number
-
jgeddes
Super User
Super UserIn the table view you can sort a column by a different column. In this case you would want to sort the month name column by a month number column.