Forum Discussion
Sorting by latest column values in Matrix
Hi there,
I'm trying to sort a matrix by the latest column values (ascending/descending), these are Jun-2021 values in my case. Been trying to find a solution to this for quite awhile now but to no successs..
Thanks in advance!
3 Replies
Anonymous,
Try this solution.
1. Create a calculated column equal to your existing [Month Year] column.
Month Year Desc Sort = DimDate[Month Year]2. Create a calculated column for sorting. This requires column [Year Month Num], with values such as 202101.
Month Year Desc Sort Order = DimDate[Year Month Num] * -13. In the Data view, sort [Month Year Desc Sort] by [Month Year Desc Sort Order].
4. Use [Month Year Desc Sort] in a visual.
Hi DataInsights
Thank you for your reply!
Apologies, I think I did not state my question clearly. What I was trying to ask was how does one sort the latest column's values for the whole matrix, e.g. Jun-2021 values for the whole matrix?
Hi Anonymous
Currently it is not possible to sort on an individual column in Matrix visual. There are some similar ideas you can vote for:
Microsoft Idea · matrix can be sorted by any column by clicking on the column header
Microsoft Idea · Sort in Matrix Visual, just like any column can be sorted in the visual in a Table.
Microsoft Idea · Matrix visual with asc and desc sorting on every column
Microsoft Idea · Add sort on a column feature to the matrix visualization
Regards,
Community Support Team _ Jing
