Power BI

Needs Votes

Custom order for legend

Vote (2690)

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)

Comments (279)

39b3c17c 7404-4526-92bd-eac0316c310d on 16 Aug 2020 03:56:26

RE: Custom order for legend

Use multiple columns to enhance the functionality "sort by" of "slicers" in Power BI by adding the possibility to "sort by other non visible columns".

E.g.
Column "month": jan, feb, mar, ... (visible in the slicer)
Column "month number": 1, 2, 3, ... (used to sort the visible fields in the slicer)

0625f7e8 8ce6-4dce-b8b1-6c9c86713efb on 16 Aug 2020 03:56:23

RE: Custom order for legend

Having a legend order matching the stacked bars value is a charting 101 issue. It has been Excel for decades. Please add this basic feature ASAP.

Thanks...

f0175a8f 2091-4f0e-902f-01527c5e3501 on 16 Aug 2020 03:56:04

RE: Custom order for legend

Would be great, my example . . . .

Either using the stacked column chart or clustered I would like to sort the following

1.) showing by months
2.) Total (sum) of categories, 8 different categories
3.) X-axis concatenate labels turn off

Issue: As soon as I try sorting the Total( sum) category by (Asc) the x-axis concatenate turn off option breaks.

In excel it works, I would like to see this working in power bi desktop/services

Again, would be great.

8d3a4137 faf0-4b96-9cf9-52e3b2d3fb33 on 16 Aug 2020 03:55:50

RE: Custom order for legend

why isn't this a thing yet? incredibly frustrating to have to come up with work-arounds for something so basic!

399c3577 b6a7-4be6-8490-f8c7bdd6a514 on 16 Aug 2020 03:55:14

RE: Custom order for legend

My short example why "Custom Sort Lists" (like in Excel) is needed

How to sort goods in stock by last sales periods by days:
361 >
181 - 360
91 - 180
61 - 90
31 - 60
1 - 30

edd6c902 b9e1-47a4-adf3-dde00bee4067 on 16 Aug 2020 03:55:07

RE: Custom order for legend

Hi,

I also agree that this future is needed. The legend on a particular visual of mine is displaying the days of the week and due to the legend automatically ordering alphabetically, the days of the week are in the wrong order!