Forum Discussion
Solved
Slicer 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
-
gra_197 just create a new column and number the months in order as
month name | month number(new column)
january | 1
feb | 2
.....
in table view , then select month number column and sort by as shown in image
and then use this month name column it will be always sorted.
If it helps please Like and Accept it as Solution