power bi sort multiple columns in data view problem

[sompolk]

I have problem about sorting multiple column in data view.
Data source I get from excel have many cloumn; column1 is date, column 3 is plant name.  In Query data is first order by column plant name and second by column date as shown below.

After I close and apply to Data View, The order of data in column date and plant name changed. How can i sort data in multiple column; first level I need sort data in column plant name ASC  and second level sort data in column date ASC.

[aj1973 · Accepted solution]

Hi @sompolk

This can help you solve your issue

https://www.sqlbi.com/articles/rankx-on-multiple-columns-with-dax-and-power-bi/

[v-henryk-mstf · Accepted solution]

Hi @sompolk ,

If you arrange multiple columns in power query and want to save the arranged results. May wish to create an index after the arrangement. After "close and apply", add an index column to the table to display the latest sort results. But in desktop, only one column can be sorted.

There is also a type of case for reference:Solved: Sorting a table using multiple columns - Microsoft Power BI Community

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[v-henryk-mstf · Accepted solution]

Hi @sompolk ,

If you arrange multiple columns in power query and want to save the arranged results. May wish to create an index after the arrangement. After "close and apply", add an index column to the table to display the latest sort results. But in desktop, only one column can be sorted.

There is also a type of case for reference:Solved: Sorting a table using multiple columns - Microsoft Power BI Community

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[sompolk · Accepted solution]

Thanks henry

[aj1973 · Accepted solution]

Hi @sompolk

This can help you solve your issue

https://www.sqlbi.com/articles/rankx-on-multiple-columns-with-dax-and-power-bi/

[sompolk]

thanks Amine Jerbi