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

0a2bdf95 1750-47b1-a02c-3fb9313d4219 on 16 Aug 2020 04:00:09

RE: Custom order for legend

Yes!! Yes!! Please implement. Also agree this would fix quite a bit of the sorting issues we see in PBI today.

Krishna Sankar's profile image Profile Picture

2344b441 114c-4e49-adb0-808d8934aa6d on 16 Aug 2020 03:59:08

RE: Custom order for legend

the way you can do this in other BI tools it to have a Dual () function in the load process or to have a sorting function as part of the visualization. it would be great if Power BI had this same kind of functionality

Krishna Sankar's profile image Profile Picture

0fa430ea 4003-4f57-890e-c3faa00e85c8 on 16 Aug 2020 03:59:05

RE: Custom order for legend

While we wait for this feature, has anyone figured a workaround? Other than changing the labels of course.

Krishna Sankar's profile image Profile Picture

30610529 94c3-483f-9079-ca9cde5d0ea1 on 16 Aug 2020 03:58:43

RE: Custom order for legend

Yes orely needed i have three criteria labelled W, W- and W+ the W needs to be in the middle!

Krishna Sankar's profile image Profile Picture

20e54d19 4cfd-4ca8-8c9d-12ce5b0e2187 on 16 Aug 2020 03:58:31

RE: Custom order for legend

Or sort by a field that is not in the visualization.

Krishna Sankar's profile image Profile Picture

91dfe2cb 9719-4aa1-a863-905bc8f47ce8 on 16 Aug 2020 03:58:01

RE: Custom order for legend

this is the standard way to look at the data folks ~!

Krishna Sankar's profile image Profile Picture

1b053fe7 2829-47b3-b058-f89052feddc1 on 16 Aug 2020 03:57:49

RE: Custom order for legend

This is one of the items stopping me from switching to Power BI

Krishna Sankar's profile image Profile Picture

3b994b3a 3db6-4f3a-addc-55830877d465 on 16 Aug 2020 03:57:49

RE: Custom order for legend

Come on Power BI team - this is very basic missing functionality!

We need to be able to stack Revenue in a given week, but we want the recognised revenue at the bottom and forecast at the top.

Krishna Sankar's profile image Profile Picture

d7d032a2 6126-429a-aa9d-1901e40db913 on 16 Aug 2020 03:57:37

RE: Custom order for legend

Visuals should have a custom sort option on multiple columns. Sometimes I want to decide how to sort data and not use natural sorting.

Krishna Sankar's profile image Profile Picture

8b94e7ae d88a-4d50-a0d9-21f995581078 on 16 Aug 2020 03:56:34

RE: Custom order for legend

I am doing a NPS report and will be good to do a leaderboard sort by NPS then RR.