Skip to main content

Power BI

Planned

Custom order for legend

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

Huan Wang 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

James Winegar 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

Stuart Charles 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

Niels 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

Sebastian Sim 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.

Krishna Sankar's profile image Profile Picture

Teodoro 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)

Krishna Sankar's profile image Profile Picture

BG 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...

Krishna Sankar's profile image Profile Picture

raynok 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.

Krishna Sankar's profile image Profile Picture

ML 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!

Krishna Sankar's profile image Profile Picture

TS 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