Skip to main content

Power BI

Planned

Custom order for legend

Vote (5212) 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 (346)
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

Krishna Sankar's profile image Profile Picture

Zac Tolfrey 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!

Krishna Sankar's profile image Profile Picture

Moose M. on 16 Aug 2020 03:54:45

RE: Custom order for legend

...so it's been over a year and MSFT still doesn't have a custom sort feature?

Krishna Sankar's profile image Profile Picture

sosi on 16 Aug 2020 03:54:45

RE: Custom order for legend

i found something, there are 3 dots in the top right corner of the chart, here you can change the order of the bars.

Krishna Sankar's profile image Profile Picture

Fred Lorrain on 16 Aug 2020 03:54:38

RE: Custom order for legend

idealy the default sorting should be

1. Folder (alpha sorted)
2. Fields and calculated column (alpha sorted)
3. Measures (alpha sorted)

Krishna Sankar's profile image Profile Picture

Jonathan Mukundu on 16 Aug 2020 03:54:13

RE: Custom order for legend

This should actually been in the first version of Power Bi. It will really making sorting much easier

Krishna Sankar's profile image Profile Picture

natan on 16 Aug 2020 03:53:59

RE: Custom order for legend

for example if i have this values in a column:
0-5,5-10,10-15,15+
and i wanted to display this value in a visual in this order.

Krishna Sankar's profile image Profile Picture

natan on 16 Aug 2020 03:53:56

RE: Custom order for legend

custom sort of strings
for example i have this ranges:
0-5,5-10,10-15,15+
and i want to display the visual in this order.

Krishna Sankar's profile image Profile Picture

Jade Doherty on 16 Aug 2020 03:53:52

RE: Custom order for legend

'@N1c0l3 - thanks your workaround solution did the trick - but yes agree this should be a standard feature to allow custom sorting