Sorting columns behavior in matrix not working

Question

Hello All&nbsp;I'm beating my head against wall on this.&nbsp; I have a matrix that I'm trying to sort my columns by dates desc.&nbsp; If I use just the date iteself, it sorts correctly descending.&nbsp; But, if I try to add a hierarchy or use both the Year and date for the colums so you can drill down from year and have both the year and date showing, the year shows ascending and the dates show descending.&nbsp;&nbsp;&nbsp;Here are the things I've tried so far:&nbsp;I created an index on the date table in descending order so 1 is the latest date with 10 being the oldest to try and sort Desc , clicked on the date field and chose sort by Index.&nbsp;I created a hierchy for Year and Week End Date and tried going that route vs adding the 2 columns separately.&nbsp;If I add the SortOrderDesc field as the first field in the columns, it sorts correctly, as soon as I remove it, it shows Year Asc, date, descI've tried multiple different scenarios and I can't seem to figure out how to solve this.&nbsp;My table:&nbsp;Shipment Year Shipment Week End Date&nbsp; &nbsp;DateKey&nbsp; &nbsp; SortOrderDesc&nbsp; (Index created in Power BI)2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022-01-15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20220115&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022-01-08&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20220108&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022-01-01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20220101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;32021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-12-25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20211225&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;42021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-12-18&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20211218&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;I'm sure I'm missing something obvious.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Has anyone else had this issue?