Forum Discussion
Matrix how to Sort within Nested Rows?
- 2 years ago
For point 1 - I agree, just swap it.
For point 2 - you can have a slicer on the canvas or put the field in teh filter pane that only has the job title and the user can use that to filter to what they want - it doesn't need to be part of the matrix visual. Another option if you would prefer to keep name and title separate it to simply turn off the stepped layout under the Rows settings.
- 2 years ago
Hi! You absolutely can, depending on what it is you want to sort. For example, if you want to sort title in a non-alphabetical way, you can assign each item a numerical value in the order you want, then sort the title by the numeric value - this way when you use Title, it is sorted in the order you assigned without having to have the numeric value actually in the visual (this is also the same way you would have month name sorted correctly by chronology, not alphabetically). Sort one column by another column in Power BI - Power BI | Microsoft Learn
For point 1 - I agree, just swap it.
For point 2 - you can have a slicer on the canvas or put the field in teh filter pane that only has the job title and the user can use that to filter to what they want - it doesn't need to be part of the matrix visual. Another option if you would prefer to keep name and title separate it to simply turn off the stepped layout under the Rows settings.
Thanks AudreyGerred. I was clearly overthinking this one.
Just on point 1, do you think there would be a method (to sort by a hidden field)? I know I can live without it - but I can already here my manager asking anyway 😂
Thanks,
- audreygerred2 years ago
Super User
Hi! You absolutely can, depending on what it is you want to sort. For example, if you want to sort title in a non-alphabetical way, you can assign each item a numerical value in the order you want, then sort the title by the numeric value - this way when you use Title, it is sorted in the order you assigned without having to have the numeric value actually in the visual (this is also the same way you would have month name sorted correctly by chronology, not alphabetically). Sort one column by another column in Power BI - Power BI | Microsoft Learn