Skip to main content
Microsoft Idea

Power BI

Planned

Custom order for legend

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

Lisa Rea on 26 May 2021 23:17:26

RE: Custom order for legend

As for the comment of "This can be done via Sort by Column already" that isn't the whole issue when it comes to stacked charts. Even with the column sort defined the legend order will not match the chart when you place the legend on either the left or right side. In these cases the legend order is the oposite of the stack order. For example, the bottom-most stack will be the top item in the legend list. So the issue, as I see it, is two-fold. First, allow an order that is manually defined and different from the default sort order for the column. Second, when placing the legend on either the left or right side the order of the legend should match the order of the stacks REGARDLESS of the defined sort order of the stacks themselves. Every tool I have used (Excel, Tableua, BO, etc.) has the legend order matching the stacks when the legend is positioned on the left or right

Krishna Sankar's profile image Profile Picture

David Hajdu on 21 May 2021 04:47:17

RE: Custom order for legend

This can be done via Sort by Column already

Krishna Sankar's profile image Profile Picture

Martin Lucas on 13 May 2021 11:07:10

RE: Custom order for legend

Need to be able to sort Legend by Value not just alphabetically

Krishna Sankar's profile image Profile Picture

Niloufar Mohaseb on 29 Apr 2021 21:14:07

RE: Custom order for legend

How many votes needed?

Krishna Sankar's profile image Profile Picture

Raluca Carmichael on 15 Apr 2021 15:50:13

RE: Custom order for legend

You should be able to order legend by wither draging the stacked bar portion and move it, or the legend itself. Why is this not a thing? I just had t go through a 30 min tutorial of creating relationships, new tables etc to be able to change the freaking order ? They should be changeable even from the format under data colours, just drag and move around. How can a company as rich as Microsoft have developers make a programme that is not intuitive. Can you tell I am frustrated?

Krishna Sankar's profile image Profile Picture

Fred Newton on 24 Mar 2021 15:45:33

RE: Custom order for legend

Add to that the ability to Wrap the legend, rather than having to page left/right to see the categorise that don't fit in the available width

Krishna Sankar's profile image Profile Picture

Ke Lo on 25 Feb 2021 16:42:13

RE: Custom order for legend

Any plan for this feature in 2021? This is really important for me, thanks.

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.