Forum Discussion
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 to sort based on finish date, but matrix visual is sorting based on name which is 1st row.
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.
Please help me
- Anonymous5 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...
Best Regards
10 Replies
- lbendlinSuper User
Please specify what you mean by row name. Maybe show a picture?
- jeevanabattuHelper I
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.
- jeevanabattuHelper I
Please help me on this
- AnonymousNot applicable
Hi Jeevana
Do you find an answer to you question . Facing same problem- jeevanabattuHelper I
Hi Siva,
No, I have to place the field which I want to sort in the First Row like in the below screenshot I want to sort Matrix visual based on Finish Date, so placed it in the First row.
Thanks,
Jeevana.
- AnonymousNot applicable
Thanks for quick resoponse.
If I do like that the visual look and feel will change. Anyway Thanks once again