Forum Discussion

jeevanabattu's avatar
jeevanabattu
Helper I
5 years ago
Solved

Row sorting is not working in matrix Visual

Hi,   I am new to Power BI, need help please!!   Is sorting in matrix visual is based on first row. I have 5 rows in matrix visual, where first row is name and 2nd row is finish date.   I want ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi jeevanabattu ,

    According to my test, this may not be possible. How should it be displayed if you want to sort by Finish field using the following sample data?

    Perhaps you can consider creating a table visual instead of matrix, then you can refer the following document by use multi-column sort for table. But doing so will lose the hierarchical levels...

    Multi-column sort for tables

    Best Regards

lbendlin's avatar
lbendlin
Super User
5 years ago

Please specify what you mean by row name. Maybe show a picture?

  • jeevanabattu's avatar
    jeevanabattu
    Helper I
    5 years ago

    Hi,

     

    Thank you for the fast response.

    Please find the below screenshot:

     

    I want to sort based on finish date, but matrix visual is sorting based on name which is 1st row value.

     

    Note: I tried sort by option in visual but it is not working

    I tried sorting the 'Finish date' column in the table, but nothing is working.

    • jeevanabattu's avatar
      jeevanabattu
      Helper I
      5 years ago

      Please help me on this

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi jeevanabattu ,

      Do you want the matrix sort the data by Finish field? If yes, please put Finish field before Milestone Name field just like below screenshot. If you keep the original fields setting, the matrix will sort the data by Milestone Name first then Finish field....

      Best Regards

      • jeevanabattu's avatar
        jeevanabattu
        Helper I
        5 years ago

        Hi,

         

        Thank you for your reply.

         

        But my client wants to sort by 'Finish date' and 'Milestone name' should be the first column.

         

        Can you please help, if that is possible.

         

        Thanks,

        Jeevana.