Forum Discussion

NickDSL's avatar
NickDSL
Helper I
3 years ago
Solved

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...
Need Help
  • NickDSL's avatar
    NickDSL
    3 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.