Forum Discussion

Helper II

6 months ago

Solved

Slicer data

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

cengizhanarslan
6 months ago
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

cengizhanarslan

Super User

6 months ago

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