Forum Discussion

9 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , You can sort on total columns(Values) in matrix and on rows columns

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      How to sort on columns? In this case i want to sort it by Business Unit which is column.

      The Business unit with highest salary should come first.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous You can do the following:

    1. Go to More Options by clicking on the ellipsis icon (three dots) on the matrix visual.

    2. Select Sort by > Salary

    3. This is the output. 

    Hope this answers your question. 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

       

       

       

      Thanks for reply, but my requirement is the Business Unit with highest salary should come first, in this case Houston city should be displayed first, then New York city, then Seattle and Los Angeles

       

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        5 years ago

        Hi Anonymous ,

         

        Create a column as below:

        Rank = RANKX('Human Resources',SUMX(FILTER('Human Resources','Human Resources'[Business Unit]=EARLIER('Human Resources'[Business Unit])),'Human Resources'[Salary]),,DESC,Dense)

        Then duplicate column "Business Unit" and choose sort by rank:

        And you will see:

        For the related .pbix file,pls see attached.

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my post as a solution!