Skip to main content
Microsoft Idea

Power BI

Needs Votes

Sort table by Column not present in table

Vote (25) Share
Sepand Gojgini's profile image

Sepand Gojgini on 04 Jun 2016 05:01:24

Currently to sort table by an attribute, you would need to add column. We are interested in ability to sort by attribute without showing the attribute. This would be done by Power User creating the report and can still be overwritten by consumer if they desire to sort by other attribute present in table.

Comments (4)
Sepand Gojgini's profile image Profile Picture

Gary Thomann on 06 Jul 2020 00:09:53

RE: Sort table by Column not present in table

Beef up the Matrix hierarchical sorting functionality as per:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11185431-add-a-multiple-columns-sort-featue 

Sepand Gojgini's profile image Profile Picture

Mark Mark on 05 Jul 2020 23:17:26

RE: Sort table by Column not present in table

This would be very helpful in Matrix when displaying in stepped view.
Stepped view does not allow to use the sorting defined in data table

Sepand Gojgini's profile image Profile Picture

David Daniele on 05 Jul 2020 23:07:59

RE: Sort table by Column not present in table

If this is an issue with the way the query is done in the backend, at least have the ability for us to sort by all columns available in the filter for the table. Other BI products like MicroStategy have had this capability for over 10 years now.

Sepand Gojgini's profile image Profile Picture

James Beresford on 05 Jul 2020 22:52:25

RE: Sort table by Column not present in table

Agree - we have a few scenarios where we want to sort by a column( e.g. RANK) but not display the rank value