Forum Discussion
Sort columns base on two columns
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?
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!!
2 Replies
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!!Hi yellowold5
You can do this in power query editor.first column by Asc
order column by descAdd 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!
