Forum Discussion
Sort slicer with text and dates
You are almost there...
Add another column with something like:
Table.AddColumn(HomologousMonth, "MonthSlicerSortOrder",
each if [CurrentMonth] then 999
else if [PreviousMonth] then 998
else if [HomologousMonth] then 997
else [MonthIndex])
And in your data model use this column as the Sort by column for the MonthSlicer column.
You are almost there...
Add another column with something like:
Table.AddColumn(HomologousMonth, "MonthSlicerSortOrder",
each if [CurrentMonth] then 999
else if [PreviousMonth] then 998
else if [HomologousMonth] then 997
else [MonthIndex])
And in your data model use this column as the Sort by column for the MonthSlicer column.
Thank you so much! I didn't even know that i could sort a column using other as reference ^^ waltheed