Forum Discussion

krist_pbi's avatar
krist_pbi
Helper I
3 years ago

Order axis for matrix visual

Hi community,   I need help with the following, is there a way I can sort the column axis (dates) from oldest to newest but from left to right? It doesn't let me do it, I have a client that doesn't...
Need Help
Show and Tell
Tips and Tricks
danextian's avatar
danextian
Super User
3 years ago

Hi krist_pbi ,

 

I tested that myself. There is no option to sort the column in a matrix unless it is sorted by  another column. So the workaround is to create a date calc column in DAX or duplicate it in PQ and then use RANKX to create a sort by column.

See sample formulas and the screenshot below

Date2 =
 'DataTable'[Date]
DateRank =
RANKX ( VALUES ( 'DataTable'[Date] ), 'DataTable'[Date],, DESC )

 

 

  • StefanoGrimaldi's avatar
    StefanoGrimaldi
    Resident Rockstar
    3 years ago

    you will do need the extra colum, you can create a column as year&month to use that as sort column for the main dat ecolumn and so it will work around it also you can try creating a calendar using a tool bravo its pretty good and efficient for createing this type of dimensional tables and other stuff: 

     

  • krist_pbi's avatar
    krist_pbi
    Helper I
    3 years ago

    Thank you, just one question, the formula you shared then has to be created as a calculated column in my Calendar table, correct? Then just sort the weeks by this column, correct?

    DateRank =
RANKX ( VALUES ( 'DataTable'[Date] ), 'DataTable'[Date],, DESC )