How to sort date slicer by month name when already using SortOrder column

[ICW1972]

This one is an oldie but a goodie.  I've not found a solution to something that seems like it should be straightforward.  Lots of posts on how to do this but they are not working for me.

I have table that has some dates.  It's not a Calendar table, just some dates.

I have a SortOrder column that is sorted in the table and in the visualization.  

February 2024 should appear first, then January 2024, etc. The dates go back to July 2023.  I always end up with the axis sorted by Month Name.

What am I doing wrong?

[Idrissshatila · Accepted solution]

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

[ICW1972 · Accepted solution]

Solution is here:

https://community.fabric.microsoft.com/t5/Desktop/Name-of-Month-in-Slicer-is-not-in-right-order/td-p...

You have to click on the table column and select a different sort column.  Very confusing for me personally.

[Idrissshatila · Accepted solution]

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

[ICW1972]

Not really.  If I have two July months (2023, 2024) that doesn't work.  That's why there is a SortOrder column to provide distinct values.

I tried your suggestion anyway and it doesn't sort. 

Thank you for replying though!

[Idrissshatila]

@ICW1972 ,

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.

[ICW1972]

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.