Skip to main content

Power BI

Inactive

Add a multiple columns sort featue

Vote (3735) Share
Narendra's profile image

Narendra on 23 Dec 2015 22:09:02

If it is possible please provide the multiple columns sort . For example I want to sort the table visualization based on Priority and severity

Administrator on 19 Apr 2024 08:31:48

This is in our backlog. Please vote to receive updates as we make progress.

Comments (248)
Narendra's profile image Profile Picture

3100799e e766-4535-879c-b77a1a9db065 on 16 Aug 2020 04:16:08

RE: Add a multiple columns sort featue

I was enjoying a nice Shiraz by an open fire when my children ran into the drawing room screaming, they revealed that upon attempting to catalogue and analyse their insect collection they were unable to sort through multiple columns within power bi. Please add this feature, for the sake of the children. Please think of the kids!

Narendra's profile image Profile Picture

48a92b39 d4d9-4982-b1a3-9705d91ff53c on 16 Aug 2020 04:16:07

RE: Add a multiple columns sort featue

It's really really necessary.

Narendra's profile image Profile Picture

ca0eef07 7663-415b-8566-fee2f140045a on 16 Aug 2020 04:15:59

RE: Add a multiple columns sort featue

Would like a Multi- Column / Advanced Sorting Option. Trying to look at freight expenses than by Sales Number of Sales Orders, but not allowing me to do what I want without the advanced sort option.

Narendra's profile image Profile Picture

8db96220 99d2-44ac-bc7e-f672aa83527d on 16 Aug 2020 04:15:44

RE: Add a multiple columns sort featue

Please add multi level (or column) sort capability to power bi.

Thanks!

Narendra's profile image Profile Picture

306b6b18 c86b-4427-a4a9-c422c1af8ce9 on 16 Aug 2020 04:15:44

RE: Add a multiple columns sort featue

Would also be nice to be able to custom sort columns and rows (e.g. by dragging column/row label in a desired order)

Narendra's profile image Profile Picture

13e47c54 cee9-48be-b512-8b51ac895ee9 on 16 Aug 2020 04:15:36

RE: Add a multiple columns sort featue

Another must have feature, come on guys , still under review. What is there to review. Please start the work

Narendra's profile image Profile Picture

72927a13 b651-46d6-a90a-79bac4241d8e on 16 Aug 2020 04:15:29

RE: Add a multiple columns sort featue

Need it Quick ! and Fast !

Just need to update Table and Matrix Visual component, it should solve 99%.

and leave the rest on power query. (build keys, use of keys.. etc)

Narendra's profile image Profile Picture

b7f4b2a3 13fc-4cd0-800a-765d050ec8cf on 16 Aug 2020 04:15:26

RE: Add a multiple columns sort featue

The best workaround I have found thus far is to use the DAX function "ISONORAFTER".
Reference: https://community.powerbi.com/t5/Desktop/Sorting-by-multiple-columns/m-p/536884#M251918
Function Details: https://docs.microsoft.com/en-us/dax/isonorafter-function-dax

Narendra's profile image Profile Picture

d45393e9 7d6e-4316-836d-5af02e89e441 on 16 Aug 2020 04:15:22

RE: Add a multiple columns sort featue

I agree, it is simply unbelievable that this basic and essential feature isn't readily available.

Narendra's profile image Profile Picture

594f27dc 1a9c-42b0-a586-3a1626d16d35 on 16 Aug 2020 04:15:17

RE: Add a multiple columns sort featue

I can't describe how frustrating it is not to have this seemingly straightforward capability. I'm scouring the internet and struggling to come up with a workaround and I can't get anything to work. Pretty please make this happen!