Skip to main content

Power BI

Needs Votes

Custom order for legend

Vote (2690) 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 20 Aug 2020 01:24:03

Thanks for the feedback. Vote to keep updated on progress for this item.

Comments (279)
Krishna Sankar's profile image Profile Picture

af075765 6e2e-458f-a0fb-0aa7e3aa998c 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

c7bd7158 051e-4cfe-bf7d-e2672afa6662 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

7df425e5 0a48-4bdc-8df9-00187af14962 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

74808517 1d10-4f11-98f5-626df6e42b6e 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

976b330d af8e-44d8-b152-e9e4b51cf293 on 16 Aug 2020 03:52:42

RE: Custom order for legend

Strongly agreed.

Krishna Sankar's profile image Profile Picture

7bbfd9fd 8843-4fa6-938b-adfcbe4d7ccc 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

b7f6a85d b076-4ead-91e0-490b514904eb on 16 Aug 2020 03:52:22

RE: Custom order for legend

Definitely needed!

Krishna Sankar's profile image Profile Picture

b7f6a85d b076-4ead-91e0-490b514904eb on 16 Aug 2020 03:52:22

RE: Custom order for legend

Yea, for all charts please!

Krishna Sankar's profile image Profile Picture

8b065a5e c719-42bb-b0c8-32050ad91d1c on 16 Aug 2020 03:52:08

RE: Custom order for legend

Can we get a similar function to Custom Sort Order just like Excel does it. This will fix quite a bit of the sorting issues we currently see in Power BI today.
For Example:
By Day of Week - Sunday to Saturday, Sun to Sat, etc
By Month of Year - January to December, Jan to Dec.

Give them a dialog or other options to control the order manually.

Krishna Sankar's profile image Profile Picture

d26bc558 9e2c-408c-ba65-1c4b8b2311f1 on 16 Aug 2020 03:52:05

RE: Custom order for legend

Essential when using buckets! Hopefully coming soon :)