Skip to main content

    Power BI

    Needs Votes

    Custom order for legend

    Vote (2690) Share
    Krishna Sankar's profile image

    Krishna Sankar on 30 Jul 2015 05:43:14

    I should be able to order the "legend" and the values for each legend category in a stacked bar chart. This is similar to "series order" feature in Excel

    Administrator on 20 Aug 2020 01:24:03

    Thanks for the feedback. Vote to keep updated on progress for this item.

    Comments (279)
    Krishna Sankar's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 16 Aug 2020 04:02:02

    RE: Custom order for legend

    We should have the ability to sort the rows appearing in a table or matrix based on a column that is not being displayed (eg a SortOrder field). Currently possible in SSRS (by default it respects the data order).

    This seems to work for charts but not for tables. For example i would like HR row data in the table to be displayed in order of Job Seniority, which is only indicated by a numerical field in the source data that i do not want to display. Currently the table defaults to alphabetical order and can only be corrected by including the SortOrder column.

    Krishna Sankar's profile image Profile Picture

    6f7b4555 d1de-41d2-8429-becad10ec0b2 on 16 Aug 2020 04:02:01

    RE: Custom order for legend

    In Tableau you can drag the fields in a chart into a different sort order and Tableau remembers it as a new sort order when the field is used again. Is PowerBI getting this feature?

    My department is evaluating whether we can switch from Tableau to PowerBI and we would need this feature.

    Krishna Sankar's profile image Profile Picture

    9048ea43 48c5-4900-b9b3-bc86a9b0e402 on 16 Aug 2020 04:01:34

    RE: Custom order for legend

    Yes please this is much needed

    Krishna Sankar's profile image Profile Picture

    e60a5918 c341-4267-b708-6a452ec560e1 on 16 Aug 2020 04:01:33

    RE: Custom order for legend

    yes please

    Krishna Sankar's profile image Profile Picture

    230e12d3 e83f-4729-be9a-f3fa66648849 on 16 Aug 2020 04:01:26

    RE: Custom order for legend

    This would be a great feature! please share us if you are implementing it

    Cheers!

    Krishna Sankar's profile image Profile Picture

    e9c9f8a6 1a4e-4c70-a057-e68b3c066cff on 16 Aug 2020 04:01:22

    RE: Custom order for legend

    definitely please add, my stacked bar charts make no sense without this haha

    Krishna Sankar's profile image Profile Picture

    1e32f274 ffac-4fe7-b281-e59e6a248f40 on 16 Aug 2020 04:01:11

    RE: Custom order for legend

    PULEASE ADD AND STAT!

    Krishna Sankar's profile image Profile Picture

    7dc3209f 9677-4ee7-a1b8-0065a7966203 on 16 Aug 2020 04:00:54

    RE: Custom order for legend

    This would be handy. There are workarounds, like creating measures for each segment and adding them individually to the chart. But that is just plain ugly.

    Krishna Sankar's profile image Profile Picture

    0ce72808 dd60-449f-bd9c-7b8aecf076e1 on 16 Aug 2020 04:00:51

    RE: Custom order for legend

    Should be a priority if Power BI really wants to be an option for dashboarding or any application people have to share with management or an audience outside of data crunchers.

    Krishna Sankar's profile image Profile Picture

    eb4bd886 d898-44ea-83ef-9b69e03910ef on 16 Aug 2020 04:00:50

    RE: Custom order for legend

    Need to easily sort stacks by values inside a column while maintaining order specified on X axis.