Forum Discussion
How to sort date slicer by month name when already using SortOrder column
Hello ICW1972 ,
if you want to only sort the months in the slicer , then you click on the month column and sort by month number
Solution is here:
https://community.fabric.microsoft.com/t5/Desktop/Name-of-Month-in-Slicer-is-not-in-right-order/td-p/3152828
You have to click on the table column and select a different sort column. Very confusing for me personally.
Super UserICW1972 ,
So you need to have a year/month column as the following:
year/month = format('YourTablename'[dateColumn],"mmm YYYY")
year/month sort = format('YourTablename'[dateColumn],"mmYYYY")
and sort the year/ month column by the year/mont sort.
Whether I sort by a distinct number or your suggestion is immaterial. The SortOrder should be observed now without changing anything and it isn't.
I tried a simple case of manually creating a table with a few rows and it still cannot sort by the SortOrder column even if it's hardcoded (1, 2, 3, 4). It's one of those things in Power BI that ought to be straightforward.