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

4c5695ed 7e50-42d7-96bc-06a1e0d6aedd on 16 Aug 2020 04:09:41

RE: Add a multiple columns sort featue

We need this! I need to show a list sorted by Work Cell then Date. Doing this with M in PowerQuery is slow and tedious. I wish this was a native feature to PowerBI.

Narendra's profile image Profile Picture

734f50a9 a092-4a0d-b737-018814c3fa79 on 16 Aug 2020 04:09:36

RE: Add a multiple columns sort featue

How is this not available and this product is a BI tool? I just wasted a lot of time on a financial report only to find that I can not organize the data showing percentage changes in order by person. I think I will go back to sql query and just display the data since this is not available. It IS very frustrating.

Narendra's profile image Profile Picture

734f50a9 a092-4a0d-b737-018814c3fa79 on 16 Aug 2020 04:09:36

RE: Add a multiple columns sort featue

Also, this may work for some cases. Concatenate your columns to where it assumes an order if you are able and then sort by that. Only problem is the ugly column you create concatenating a bunch of stuff shows on your visual.

Narendra's profile image Profile Picture

43c12817 22aa-4d1d-ae3e-1bfb497460c2 on 16 Aug 2020 04:09:36

RE: Add a multiple columns sort featue

We are converting reports from SSRS to Power BI. Our client wants the the same functionality, which is to have the reports sorted by multiple columns.

Narendra's profile image Profile Picture

a90d0141 2f0b-4745-9ef8-f423bb5fecbf on 16 Aug 2020 04:09:35

RE: Add a multiple columns sort featue

Basic and really essential feature

Narendra's profile image Profile Picture

ba22feb1 5512-4ffc-822b-93c69433a5de on 16 Aug 2020 04:09:15

RE: Add a multiple columns sort featue

I'd like to sort by year and then by sales/time/counts etc. This is a function that is really needed.

Narendra's profile image Profile Picture

febd0aeb c5bb-46c0-aaf3-ce96709f4cb2 on 16 Aug 2020 04:09:15

RE: Add a multiple columns sort featue

Really needed in real business world!

Narendra's profile image Profile Picture

082ea458 5e70-4eb7-9873-617052df0351 on 16 Aug 2020 04:09:14

RE: Add a multiple columns sort featue

Basic and really esential feature.

Narendra's profile image Profile Picture

025e15db 6f3e-4026-a429-adc4137c1665 on 16 Aug 2020 04:09:12

RE: Add a multiple columns sort featue

This is basic. BusinessObjects automatically sorts by columns left to right, with options to sort by any column(s) and even custom sorting.

Narendra's profile image Profile Picture

78a08b43 c35b-45f7-bf46-89f58f0b4d74 on 16 Aug 2020 04:08:48

RE: Add a multiple columns sort featue

It's kind of silly that this is not already a thing since excel can easily do this. Please allow the option to sort on more than one column in a table or matrix.