Skip to main content
Microsoft Idea

    Power BI

    Planned

    Custom order for legend

    Vote (4968) 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 18 Oct 2022 00:54:14

    Update 10/17: This is now in our upcoming roadmap and we will share more details in the coming months. Mo

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

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

    Shawn Alpay on 16 Aug 2020 04:04:55

    RE: Custom order for legend

    The stacked bar chart visual is borderline useless without repairing this.

    Krishna Sankar's profile image Profile Picture

    Power BI User on 16 Aug 2020 04:04:44

    RE: Custom order for legend

    Very important if you warnt to avoid misinterpretations

    Krishna Sankar's profile image Profile Picture

    Javier Van Dam on 16 Aug 2020 04:04:34

    RE: Custom order for legend

    very important! please add

    Krishna Sankar's profile image Profile Picture

    Christopher Eby on 16 Aug 2020 04:03:51

    RE: Custom order for legend

    when legend positioning is 'left' or 'right', it's in inverse order to the stacked bars themselves!

    Krishna Sankar's profile image Profile Picture

    Nuno on 16 Aug 2020 04:03:07

    RE: Custom order for legend

    '+1 basic formatting request... it should be added across all visuals where this would apply

    Krishna Sankar's profile image Profile Picture

    Vincent Ziyu Ding on 16 Aug 2020 04:02:25

    RE: Custom order for legend

    It could be easier for create flexible chart

    Krishna Sankar's profile image Profile Picture

    Swapnil on 16 Aug 2020 04:02:07

    RE: Custom order for legend

    Currently "Sort By Column" Option is not enabled for PowerBI Service as Data Source. I can understand Modeling is disabled, but why custom sort.
    There are times When I want to sort by a column which I don't Want in Report.

    Krishna Sankar's profile image Profile Picture

    Power BI Ideas Admin 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

    Power BI User 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

    Arne on 16 Aug 2020 04:01:34

    RE: Custom order for legend

    Yes please this is much needed