Forum Discussion
Matrix chart Column sort desc order
Dear All,
I was trying to build a Matrix chart in that unable to sort column (Date) in the desc order, in the source date value is available in the date & time value on each row.
Request you to share your thoughts or inputs.
Regards,
Ravi Kancharla.
2 Replies
ravi10feb1949 , if date is on the column of matrix then create these two columns
Date 1 = [Date]
Date Sort = rankx('Date', [Date],,desc, dense)
Sort date1 on date sort and use that on the column
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-cDear Amit,
Thanks for your reply, however the similar way i have tried and no luck.
Please refer attached image FYI.
