Skip to main content
Microsoft Idea

    Power BI

    Planned

    Custom order for legend

    Vote (4979) 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 (342)
    Krishna Sankar's profile image Profile Picture

    ElliotP on 16 Aug 2020 03:53:31

    RE: Custom order for legend

    100% agreed. Allows you to avoid having to create a date workout for custom date hierarchy structures.

    Krishna Sankar's profile image Profile Picture

    James on 16 Aug 2020 03:53:28

    RE: Custom order for legend

    This is a must.

    Krishna Sankar's profile image Profile Picture

    Power BI User on 16 Aug 2020 03:53:09

    RE: Custom order for legend

    waterfall charts currently only sort by category. Need to have the ability to sort by the measure, as is present in column reports.

    Krishna Sankar's profile image Profile Picture

    M.R. on 16 Aug 2020 03:53:08

    RE: Custom order for legend

    Would be very useful, please add this feature!

    Krishna Sankar's profile image Profile Picture

    Robert.Grooters on 16 Aug 2020 03:53:03

    RE: Custom order for legend

    I have the same issue. The Power BI Team needs to provide some method to manually select the legend order.

    Krishna Sankar's profile image Profile Picture

    Colby on 16 Aug 2020 03:53:02

    RE: Custom order for legend

    Waterfalls only sort from increment to decrement for one measure (Variance to Budget) in my case, when switching to other measures (i.e. Variance to Forecast) the cart does not order by value and instead orders by the item names alphabetically in the x-axis. There is no sorting option to change this

    Krishna Sankar's profile image Profile Picture

    Woody Sellers on 16 Aug 2020 03:52:43

    RE: Custom order for legend

    Yes custom sort order is absolutely essential! For instance I have categories Research, Analyze, Develop which should display in that order.

    Krishna Sankar's profile image Profile Picture

    Power BI User on 16 Aug 2020 03:52:42

    RE: Custom order for legend

    Strongly agreed.

    Krishna Sankar's profile image Profile Picture

    Power BI User on 16 Aug 2020 03:52:36

    RE: Custom order for legend

    Yes, please. Ordered alphabetically sometimes does not make much sense. It'll be appreciated if the order of the column/row label of table or matrix could be customised as well, just like Excel does.

    Krishna Sankar's profile image Profile Picture

    Power BI User on 16 Aug 2020 03:52:22

    RE: Custom order for legend

    Definitely needed!