Skip to main content

    Power BI

    New

    Filters & Sorting on Header row in Matrix & Table visuals

    Vote (18) Share
    's profile image

    on 08 Jul 2018 05:46:58

    To allow for filtering and sorting using the header row in visuals such as table and matrix. This would work in the same way you can sort and filter in Excel.

    Comments (4)
    's profile image Profile Picture

    1fac0baf 9610-4152-8bad-924d339565a1 on 06 Jul 2020 00:09:53

    RE: Filters & Sorting on Header row in Matrix & Table visuals

    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 

    's profile image Profile Picture

    317d6c82 e0e7-4cd5-9cc8-136dd5c3bc13 on 06 Jul 2020 00:01:53

    RE: Filters & Sorting on Header row in Matrix & Table visuals

    Filters in the title row would avoid placing additional splicers in reports and save space. Also aligns with Excel.

    's profile image Profile Picture

    cc79f23a 1cab-48e3-9162-236a6192eb6b on 05 Jul 2020 23:31:50

    RE: Filters & Sorting on Header row in Matrix & Table visuals

    This feature could allow avoiding having too many slicers on the report canvas. Slicers could be used for most important dimensions but user could still apply filtering on other fields

    's profile image Profile Picture

    c0607ca9 8c30-4c1d-bd80-94db118d54ec on 05 Jul 2020 23:24:15

    RE: Filters & Sorting on Header row in Matrix & Table visuals

    We have slicers to do that right?