Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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?
Solved! Go to 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!!
Proud to be a Super User! | |
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!
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!!
Proud to be a Super User! | |
User | Count |
---|---|
84 | |
76 | |
72 | |
47 | |
37 |
User | Count |
---|---|
111 | |
56 | |
51 | |
42 | |
42 |