Sort columns base on two columns

[yellowold5]

Hi everyone, I wanna create a custom sort columns for my matrix visuals base on two columns,
values and order:

Value	order
1	3
2	2
3	1
4	3
5	2
6	2
7	3
8	0
9	0
10	1
11	2
12	3
13	3
14	2
15	3
16	1
17	2
18	3
19	2
20	1

want to have one sort columns as value asc and orde desc like this:

value	order
1	3
1	2
2	2
5	1
7	1
20	1
20	1
20	1

Is this possible to do in a matrix?

[Uzi2019]

Hi @yellowold5 
You can do this in power query editor.

first column by Asc
order column by desc

Add index column

save and apply

select your value > sort by column

This will sort you data according to your ASc+desc combination

Note : your complete table will sort according to these 2 values not only your Matrix.

I hope I answered your question!

[rajendraongole1 · Accepted solution]

Hi @yellowold5 -  Sorting a matrix visual based on multiple columns directly within the matrix itself is not supported. However, you can achieve a similar effect by creating a custom column in your data model that combines the two sorting criteria as a workaround.

eg: create a new column with concatenates the Value and Order columns with a "-" separator 

add this column in your matrix visual and use sort from more options

Once you have sorted the matrix visual using the new column, you may want to hide or remove this column from the field list to avoid confusion for report. (hide the column from report view).

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!