How to sort matrix columns in descending order

[Anonymous]

Hi all,

Is there any way to sort matrix columns in descending order? I don't think there's an option for that but maybe there's a workaround?

See below:

[v-yuta-msft]

@Anonymous ,

 You need to create a rank column using function like RANKX() 

RANKX(<table>, <expression>[, <value>[, <order>[, <ties>]]])  

Then add the rank column to matrix visual and sort by the rank column based on your senario.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[crocus · Accepted solution]

You need to create a sort column and then use 'Modeling' / 'Sort by Column'.

In Power Query you can do something like this:

Table.AddColumn(#"Previous Step", "Alias Sort", each - ([Alias])

 So it would look like:

Alias           Alias Sort

1                   -1

2                   -2

3                   -3

Make sure 'Alias Sort' is a whole number.

Then highlight 'Alias' and go to Modeling / Sort by Column and choose Alias Sort.

You matrix should sort in a descending manner.

[ThomasiBB]

Alternativ is to AddIndexColumn("table","Com_name",-1,-1)