Forum Discussion
power bi sort multiple columns in data view problem
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.
Hi sompolk
This can help you solve your issue
https://www.sqlbi.com/articles/rankx-on-multiple-columns-with-dax-and-power-bi/
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.Thanks henry
4 Replies
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.Thanks henry
Hi sompolk
This can help you solve your issue
https://www.sqlbi.com/articles/rankx-on-multiple-columns-with-dax-and-power-bi/
thanks Amine Jerbi