Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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:
Solved! Go to Solution.
You need to create a sort column and then use 'Modeling' / 'Sort by Column'.
In Power Query you can do something like this:
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.
@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.
You need to create a sort column and then use 'Modeling' / 'Sort by Column'.
In Power Query you can do something like this:
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.
Alternativ is to AddIndexColumn("table","Com_name",-1,-1)