topic Re: Row sorting is not working in matrix Visual in Developer

Row sorting is not working in matrix Visual

jeevanabattu — Mon, 22 Mar 2021 14:17:18 GMT

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

Re: Row sorting is not working in matrix Visual

lbendlin — Tue, 23 Mar 2021 00:12:05 GMT

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

Re: Row sorting is not working in matrix Visual

jeevanabattu — Tue, 23 Mar 2021 03:38:51 GMT

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.

Re: Row sorting is not working in matrix Visual

jeevanabattu — Thu, 25 Mar 2021 04:41:10 GMT

Please help me on this

Re: Row sorting is not working in matrix Visual

Anonymous — Thu, 25 Mar 2021 07:24:02 GMT

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

Re: Row sorting is not working in matrix Visual

jeevanabattu — Thu, 25 Mar 2021 07:33:06 GMT

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.

Re: Row sorting is not working in matrix Visual

Anonymous — Thu, 25 Mar 2021 08:10:30 GMT

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

Re: Row sorting is not working in matrix Visual

Anonymous — Wed, 02 Feb 2022 20:42:12 GMT

Hi Jeevana
Do you find an answer to you question . Facing same problem

Re: Row sorting is not working in matrix Visual

jeevanabattu — Thu, 03 Feb 2022 02:55:55 GMT

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.

Re: Row sorting is not working in matrix Visual

Anonymous — Thu, 03 Feb 2022 04:46:42 GMT

Thanks for quick resoponse.
If I do like that the visual look and feel will change. Anyway Thanks once again

Re: Row sorting is not working in matrix Visual

Anonymous — Fri, 12 Aug 2022 20:35:27 GMT

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.