Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

sort column values Alphabetically in Matrix visual

Hello All,

 

when i bring columns os table into rows field of matrix field, i want those values to displayed in alphabetical order. How can i do this?

 

 

Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Anonymous ,

     

    Click the ellipse on the top-right hand of the matrix visual. Select "Sort by" and select the column name in the "Rows" field. Then click "Sort acsending" as below:

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi

     

    This is easy to do - just open up the menu on the right and click sort Ascending.

    As you can see in the example below this changes the sort order from default (which is however it comes through in the data table) to aphabetic, for string values. 

     

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    6 years ago

    Anonymous ,

     

    Click the ellipse on the top-right hand of the matrix visual. Select "Sort by" and select the column name in the "Rows" field. Then click "Sort acsending" as below:

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.