Forum Discussion
Helper IHow to let user sort matrix by specific months?
Hi robbert-bi
Matrix can be sorted by the total column or by the row category. Column category is sorted alphabetically in ascending order or by custom column sort. If you want to sort it by the total row, attached is a round about way to do it.
Super Userrobbert-bi , Sort on Measure on column is not possible. But if you want desc sort on Month no. You can do it using sort column
Assume you have two column , Month Year, and Month year Sort to sort month year asc
You can create one
Month Year 1 = [Month Year]
Month Year Sort desc = rankx('Date', [Month Year Sort])
Now mark Month Year Sort desc as sort column for Month Year 1 and use that in visual
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Helper IHi amitchandak . Thanks for the response. I know how to sort the months. It is about sorting the values within the months, so on the vertical axis of my matrix.