Forum Discussion

powerbihelp87's avatar
powerbihelp87
Helper V
6 years ago
Solved

Sort on Matrix with unpivot data?

Hi! Is there a way I can sort by a row?  Below is a Matrix row example:   (Gross Sales, Profit, HR are value type.  The numbers are the value and the Brands are brand field)     Brand A ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    You can accomplish this by making a matrix visual with your 3 measures in the values area, and in the format option choose "Show on Rows" in Values area.  Put your Brand column as the column headers, and then use the Ellipsis in upper right of the matrix to Sort by Profit.

     

    If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

You can accomplish this by making a matrix visual with your 3 measures in the values area, and in the format option choose "Show on Rows" in Values area.  Put your Brand column as the column headers, and then use the Ellipsis in upper right of the matrix to Sort by Profit.

 

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

  • powerbihelp87's avatar
    powerbihelp87
    Helper V
    6 years ago

    such an easy fix, don't know why I never use this without transforming everything! Thanks so much