Sorting a date column by another column not working

[NickDSL]

Hi so I have the following matrix.

I would like to sort in the following way based on this dimension table

I go to Sort by Column and select the Base Act Order column but my dates in my matrix do not update to this new ordering.

In my matrix I have added Period in the left column then, I am trying to sort by Base Act Order.

Is there something I'm doing wrong? Why am I not getting the expected result?

[v-xinruzhu-msft]

Hi @NickDSL 

You can create a measure

Measure = RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[Column1])),,ASC)

Then close the "Text wrap" of the "Column header" in table visual 

Then put the measure to the visual and set its width to 0

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NickDSL · Accepted solution]

Found my own janky solution.

It was because of date data type.

In the query I set the Period/Date column to text type then I was able to sort by my Base Act Order column.

I took it a step further and added a conditional column in the query to find columns that begin with 1/1, 2/1, 3/1, etc and added the month name then switched it back to date type after the conditional column step.

My matrix and graphs are now sorting correctly.

If anyone has a better solution I'd be happy to hear.