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

b9ebead3 ea02-4eed-bca1-c1275491dc7c on 16 Aug 2020 03:58:10

RE: Add a multiple columns sort featue

Please add this.

Narendra's profile image Profile Picture

f71c9546 45d4-4944-866c-c322ceab25e2 on 16 Aug 2020 03:58:01

RE: Add a multiple columns sort featue

In matrix visual: First sort by field 1 and then by field 2 etc - this is an essential requirement! E.g. First sort by Total, then by month. Thanks.

Narendra's profile image Profile Picture

8f116f21 abb9-45d1-b150-826957117df1 on 16 Aug 2020 03:57:37

RE: Add a multiple columns sort featue

Please add this feature. It would be really really helpful!!

Narendra's profile image Profile Picture

276e69a9 8e0d-4460-a6ad-3a62d71a649e on 16 Aug 2020 03:57:29

RE: Add a multiple columns sort featue

Even Excel knows this functionality. :-) It would be a very nice to have when sorting on yearweeknumber.

Narendra's profile image Profile Picture

389f40e7 5ded-4423-85ee-6d43638308cd on 16 Aug 2020 03:56:38

RE: Add a multiple columns sort featue

Need this too!

Narendra's profile image Profile Picture

ec19c679 3dd8-4963-be87-92f3712036b1 on 16 Aug 2020 03:56:32

RE: Add a multiple columns sort featue

Please, I need this

Narendra's profile image Profile Picture

272f9aa8 c9e5-4987-a38c-8845f5c4c41f on 16 Aug 2020 03:56:30

RE: Add a multiple columns sort featue

Adding to the chorus for inclusion of multi-column sorting (for either table visualizations or underlying queries). This is a very basic reporting task which is trivial to do in Excel or SQL. I am shocked to find out it is not possible in Power BI. My Fortune 500 organization is evaluating Power BI for possible use at an enterprise level, but this sort of deficiency precludes full-scale adoption.

Narendra's profile image Profile Picture

b451ffb1 d692-44d2-b424-0658cecedeed on 16 Aug 2020 03:56:28

RE: Add a multiple columns sort featue

Please add this.

Narendra's profile image Profile Picture

d0da2833 a16d-4c90-8978-14ca0714b520 on 16 Aug 2020 03:56:26

RE: Add a multiple columns sort featue

Please add this feature ASAP. It's really needed.

Narendra's profile image Profile Picture

a870d0f4 38a8-44f5-8db8-5265159c16d8 on 16 Aug 2020 03:56:10

RE: Add a multiple columns sort featue

This is called Advanced Sorting in most BI tools. It usually opens a pop-up window where you can select the first column you want to sort on on and the associated sorting order.
Then you can add other columns you want to sort on next.
It should also give you the possibility to move columns up and down to manage the order in which the sorting should be applied