Forum Discussion
Sorting a date column by another column not working
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?
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.
2 Replies
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.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.
