Forum Discussion
Row sorting is not working in matrix Visual
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...
Best Regards
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.
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...
Best Regards
Hey jeevanabattu Anonymous
This is technically possible if you are using regular columns or calculated columns, not with measures though. If you use the Data tab and select the table you have your data located in. Select the "Milestone Name" column, then open "Sort by Column" drop down in the column tools ribbon and select "Finish". This will sort your Milestone Names by your Finish column. In the example below, Account would be your Milestone Names column. And you would select Finish in the drop down.