Forum Discussion

AlexS2023's avatar
AlexS2023
Icon for Helper I rankHelper I
2 years ago
Solved

Matrix how to Sort within Nested Rows?

Hi all,   I have a matrix showing how many employees we've assigned to a given "cost center" by date, with additional rows to show the employee names. This worked great, but now I've been asked to ...
  • audreygerred's avatar
    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.

  • audreygerred's avatar
    audreygerred
    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