Slicer data

[gra_197]

• 

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

Many thanks

[Anonymous]

Hi @gra_197,

Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[Anonymous]

Hi @gra_197,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @jgeddes , @elitesmitpatel and @cengizhanarslan  for prompt and helpful responses.

Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[cengizhanarslan · Accepted solution]

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.