Slicer data

[gra_197]

• 

  Hi, How can I get the above slicer to play ball, the months are all over the place.

Many thanks

[cengizhanarslan]

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

[elitesmitpatel]

@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 

[jgeddes]

In 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.