Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
5 years ago
Solved

Reversing Date Axis Matrix

Hi all,   Is it possible to sort date axis in a matrix from newest to oldest?        
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi HenryJS ,

    For my test ,  to avoid "circle", you could creata a new table using the following formula:

    Table 2 =
SUMMARIZE (
    'Table',
    'Table'[Date],
    'Table'[Type],
    'Table'[Value],
    "index", RANKX ( ALL ( 'Table' ), 'Table'[Date],, DESC )
)

    Then  select Date column ,sort by Index column, so that  dates in calculated table could be in descending order in Matrix 

    Here is the pbix file.

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please upload some insensitive data samples and expected output.

    Best Regards,
    Eyelyn Qin

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HenryJS  you will have to create a index colum in Power query editor for the sorting to work



sort the column based on Index number




The expected result are as below

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍



  • HenryJS's avatar
    HenryJS
    Post Prodigy
    5 years ago

    Anonymous the 'week ending' column I am trying to do the sort to is in a DAX table. Is it possible to do for a column like this?