Skip to main content
Microsoft Idea

Power BI

Planned

Custom order for legend

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

Steven Hoover on 03 Feb 2022 22:40:31

RE: Custom order for legend

This is extremely important, I have reports I can't move into powerbi cause I can't order the buckets in the legend and the seemingly random chosen isn't readable.

Krishna Sankar's profile image Profile Picture

Bastian Baur on 03 Feb 2022 07:03:51

RE: Custom order for legend

push!

highly requested feature from our departments

Krishna Sankar's profile image Profile Picture

Dmitri Ivanov on 05 Jan 2022 19:15:03

RE: Custom order for legend

Sort by value please!! Small multiples already has that feature, why not legend?

Krishna Sankar's profile image Profile Picture

Thomas Joel Farrar on 22 Dec 2021 11:22:16

RE: Custom order for legend

Agree, desperately needed.

Krishna Sankar's profile image Profile Picture

Nick Lor on 30 Nov 2021 15:28:34

RE: Custom order for legend

Bump. This is desperately needed.

Krishna Sankar's profile image Profile Picture

Kate West on 20 Oct 2021 09:09:23

RE: Custom order for legend

The related suggestion for correcting the default sort order needs more votes, for those who are interested: https://ideas.powerbi.com/ideas/idea/?ideaid=b1363cc1-0810-462d-8801-0e64973751c7

Krishna Sankar's profile image Profile Picture

Kate West on 20 Oct 2021 09:06:34

RE: Custom order for legend

The legend should be in the same order as the stacked bar charts as default. No one wants them in opposite order, it is confusing for the reader and therefore bad practice. Why was it programmed this way in the first place?

Krishna Sankar's profile image Profile Picture

David Heiss on 07 Sep 2021 14:14:08

RE: Custom order for legend

I always use this trick (or almost something like this)

https://www.youtube.com/watch?v=uZLmWz60_do

Had always worked correct for me

Krishna Sankar's profile image Profile Picture

Nedelina Tasheva on 30 Aug 2021 06:45:27

RE: Custom order for legend

Hi, 



It will be great to have this feature indeed. 

As a workaround I use the custom conditional columns.


  • You insert a new conditional column in the data table (I called it order by) 

  • Assign  a number for each value in the desired column(column A) for which you want to assign the custom order. If you have 10 values you want to put in specific order you use the number from  1 to 10.

  • Make sure your new column is with data type Number. Then close & apply the changes,

  • Select the column (Column A) to which you want to apply custom order,

  • Once you select the (Column A) on the top new tab Column tools will  appear

  •  Select sort by and select the new column with the assigned number for the values in your column

  •  It works well for me as a workaround to sort and order everything the way I want to. The downside is that it is manually maintained. 




Hope that helps, 

Best regards, 

Nedelina 
Krishna Sankar's profile image Profile Picture

Naomi van den Beukel on 27 Jul 2021 15:03:04

RE: Custom order for legend

How is simple functionality like this not yet a feature in Power BI? I keep running into imo pretty basic things that are simply not possible. Please add this ASAP!