Forum Discussion
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
-
5 Replies
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.
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 Solution1) 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
-
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 KumarHi 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
