Forum Discussion
Sorting the slicer
Hi peeps! I have the month name column and it has been automatically ordered by alphabet, is there any way to resort by the corrent month order as it should be in real life? Thanks is advance...
Anonymous , Create a sort column and mark that as the sort column for the month
Example date table
Month Sort = month([Date])
Month = format([date],"MMMM")
Sort month on Month Sort : https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
amitchandak
Super User
Super UserAnonymous , Create a sort column and mark that as the sort column for the month
Example date table
Month Sort = month([Date])
Month = format([date],"MMMM")
Sort month on Month Sort : https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
I fixed it, my problem was not specifying the Month nr key correctly, it's ok now. Thank you for your help too, that also does the trick!