undefined

[Anonymous]

Hi All,

I have a table with few web IDs and its corresponding service IDs based on fuell type,Reason code and dates.

I want to sort the table in such a manner that My web IDs are sorted and all the columns associated with it i.e fuel type, reason codes, dates etc are sorted on its own as per web IDs.

Web ID	Service ID	Fuel Type	Status Reason	Created Date	Recorded Date
10001	S001	SOLAR	E001	24/06/2020 06:00:00	25/06/2020 06:00:00
10001	S002	CNG	E004	25/06/2020 11:00:00	27/06/2020 11:00:00
10001	S003	GAS	E001	28/06/2020 08:00:00	30/06/2020 08:00:00
10001	S004	SOLAR	E010	28/06/2020 14:00:00	29/06/2020 14:00:00
10002	S123	CNG	E004	25/06/2020 02:00:00	27/06/2020 04:00:00
1000	S212	CNG	E001	22/06/2020 10:00:00	25/06/2020 10:00:00
1000	S216	SOLAR	E010	24/06/2020 16:00:00	27/06/2020 18:00:00

I tried applying "Sort ascending" on Web id and then placing all the columns in the sort formula. i,.e {Colum1,ascending},{column2, ascending}

This is working fine in power query editor but as soon as i am applying close and apply, the sort is getting distorted.

Can anyone please help in this multi sort column issue please.

[dax]

Hi @Anonymous ,

As @lbendlin  mentioned, if you want to show specific sort, we usually sort this in visual part. Sort in power query will change when you put data in visual, it is just data model preview. You could refer to Table looks different in Query editor and Table View (third reply) for details.

By the way, you could refer to @lbendlin 's second link for multiple sort in visual. I forget this feature, he also share this feature to me.

Best Regards,
Zoe Zhi

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

[lbendlin · Accepted solution]

@dax Zoe, see here

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-2020-feature-summary/#_Multi-column_...

[dax]

Hi @lbendlin ,

Oh, it's my mistake, I forget this feature. Thank you for your sharing! @lbendlin 

Best Regards,
Zoe Zhi

[lbendlin]

You don't need to sort in Power Query unless that is required for the next transformation steps.

In the Power BI UI you can put your data in a table and sort that table by multiple columns.

[Anonymous]

Hi @lbendlin ,

Thanks for the link. This trick works in the report tab(sift + left click) easily, I tried and it got successful.

I want to do it in the DATA tab for calculations.

Anyway is it possible on the data tab ?

[lbendlin]

Calculations in the data tab?

[Anonymous]

I am sorry,My bad 
Just an amatuer 🙂 
Thanks @lbendlin , @dax  for the solution.