Skip to main content

    Power BI

    New

    Custom Sort/Order Table or Matrix

    Vote (17) 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

    87efaec5 53ef-4e39-9a20-e45a68d362ff 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

    1fac0baf 9610-4152-8bad-924d339565a1 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

    75d67bcc 21b4-4434-a12f-1f0280ee31a7 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.