Skip to main content
Microsoft Idea

Power BI

Planned

Custom order for legend

Vote (4984) 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

Les Campbell on 16 Aug 2020 04:09:12

RE: Custom order for legend

Its a simple request that would add just another layer of customization instead of having to do work arounds.

Krishna Sankar's profile image Profile Picture

Power BI User on 16 Aug 2020 04:09:08

RE: Custom order for legend

Seriously three years and still nothing for something so basic and so important....
I mean what's the point of a stack bar if it's not sorted by column ?

Krishna Sankar's profile image Profile Picture

Austin on 16 Aug 2020 04:09:00

RE: Custom order for legend

Essential for having a chart that looks appealing as time moves to the right. Without the ability to sort the order, you are left with "white space" when things taper off. Having the ability to place the longest running activities on the bottom would ensure minimal gaps.

Krishna Sankar's profile image Profile Picture

Moises Medina on 16 Aug 2020 04:08:52

RE: Custom order for legend

This feature is critical to have useful visuals. Currently, line graphs with more than 15 graphs are very difficult to analyze since there is no good way to determine which lines have the most impact.

Krishna Sankar's profile image Profile Picture

CC on 16 Aug 2020 04:08:32

RE: Custom order for legend

Still a feature that is needed: Makes the visual flow and subsequent interpretation easier for users. UX is still important and needs to be supported through features like this.

Appreciating the work in the other ideas and hope this can be considered very soon...

Krishna Sankar's profile image Profile Picture

Scott Tollafield on 16 Aug 2020 04:08:30

RE: Custom order for legend

Just ran into the exact same need. I'd like to sort by rank in the overall data set. (i.e. for me this would put what is by far always the tallest bar on the bottom of the stack.)

Krishna Sankar's profile image Profile Picture

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

RE: Custom order for legend

This would be valuable when showing values that align linearly with the process being measured

Krishna Sankar's profile image Profile Picture

Oksana Kiselova on 16 Aug 2020 04:08:19

RE: Custom order for legend

It is weird, that there is no opportunity to change order of legends. In analysis this is very important to show data logically, not chaotically.
Has this problem been solved?

Krishna Sankar's profile image Profile Picture

Power BI User on 16 Aug 2020 04:08:15

RE: Custom order for legend

This function is very important, please add it.

Krishna Sankar's profile image Profile Picture

Power BI User on 16 Aug 2020 04:08:09

RE: Custom order for legend

can we have all excel features please