Sorting by latest column values in Matrix

[Anonymous]

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!

[v-jingzhang]

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

[DataInsights]

@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] * -1

3. In the Data view, sort [Month Year Desc Sort] by [Month Year Desc Sort Order].

4. Use [Month Year Desc Sort] in a visual.

[Anonymous]

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?