Skip to main content

    Power BI

    Planned

    Custom order for legend

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

    Brandon C on 06 Feb 2021 17:13:00

    RE: Custom order for legend

    Simple chart designs like this need to be added to Power BI.

    Krishna Sankar's profile image Profile Picture

    Yevhen Ovsiannikov on 12 Jan 2021 18:11:03

    RE: Custom order for legend

    Chart formatting is extremely poor compared to Excel. I acknowledge that responsive design has certain trade-offs, but having more controls would be extremely useful.

    Krishna Sankar's profile image Profile Picture

    Bevan Ward on 15 Oct 2020 01:20:22

    RE: Custom order for legend

    I have some dirty hacks by suffixing legend items with 00n, for example but this really makes this chart less effective than it should be. I have to use R instead to be able to get this chart quickly given greater control - unfortunate that this has not been addressed.

    Krishna Sankar's profile image Profile Picture

    Gidi - on 09 Oct 2020 09:15:31

    RE: Custom order for legend

    This is already possible using custom sort order right? Example here: https://www.seerinteractive.com/blog/reorder-powerbi-legend/

    Krishna Sankar's profile image Profile Picture

    Ekkehard Lang on 15 Sep 2020 14:16:40

    RE: Custom order for legend

    This feature is really needed and useful

    Krishna Sankar's profile image Profile Picture

    Atif Siddiqui on 16 Aug 2020 10:00:26

    RE: Custom order for legend

    This is very valuable feature. ... it helps readability if certain things are in chronological order. For instance, if we are tracking how many issues are there in todo, in progress, in review or completed.. .. current sort order by highest to lowest value (or count of issues in each category) is not really read-able friendly. rather, i should have an ability to sort in this sequence, todo, in progress, in review, completed.

    and not only readability, it will also add a bit of random design. currently everything seems flowing from left to right, if i have some random heights in sequence, it would look better as a pure classical Manhattan graph.

    Please add this feature of "Axis Sequence" and list down all legends that user can drag and drop to change order.

    thanks.

    Krishna Sankar's profile image Profile Picture

    Lachlan Duncan on 16 Aug 2020 04:20:31

    RE: Custom order for legend

    agree with the thought below to extend this to other stacked chart types

    Krishna Sankar's profile image Profile Picture

    Power BI User on 16 Aug 2020 04:20:22

    RE: Custom order for legend

    Is there a roadmap on when this feature is planned to be released?

    Krishna Sankar's profile image Profile Picture

    Patrick routier on 16 Aug 2020 04:20:05

    RE: Custom order for legend

    Yes, I agree vith this suggestion.
    please let us know when available ;-)

    Krishna Sankar's profile image Profile Picture

    Mike Honey on 16 Aug 2020 04:20:05

    RE: Custom order for legend

    Please fix this asap, and extend to the stacked area chart also. The way it currently displays is totally counter-intuitive - the legend is in the reverse order to the chart!

    So many complex features have been rolled out in the 5 years since this was raised, supported by thousands of votes, hundreds of comments. It's hard to believe it is still neglected.