Skip to main content
Microsoft Idea

Power BI

Needs Votes

Custom Sort/Order Table or Matrix

Vote (27) Share
Anirudh's profile image

Anirudh on 06 Jul 2018 09:59:15

Why is it so complicated to custom sort or order a column in power bi table or matrix? This is an extremely simple and basic requirement for any BI dashboard and it shouldn't be such a hassle to create Indices every time to sort.
It doesn't seem practical to create indices for 10 columns each time I need to sort.

Comments (3)
Anirudh's profile image Profile Picture

Power BI User on 06 Jul 2020 00:16:02

RE: Custom Sort/Order Table or Matrix

Same with rows. In a P&L statement, I need to put items in sequence. Do you understand?! SEQUENCE!!!

Anirudh's profile image Profile Picture

Gary Thomann on 06 Jul 2020 00:09:53

RE: Custom Sort/Order Table or Matrix

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 

Anirudh's profile image Profile Picture

CRAIG S MYERS on 05 Jul 2020 23:59:47

RE: Custom Sort/Order Table or Matrix

Columns in a matrix should have the same options as a pivot table in Excel. A report designer should be able to move columns left or right, beginning or end.