Skip to main content

Power BI

Planned

Custom order for legend

Vote (5179) 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

Power BI User 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

Power BI User on 16 Aug 2020 03:52:22

RE: Custom order for legend

Definitely needed!

Krishna Sankar's profile image Profile Picture

Power BI User on 16 Aug 2020 03:52:22

RE: Custom order for legend

Yea, for all charts please!

Krishna Sankar's profile image Profile Picture

Vito 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

Power BI User on 16 Aug 2020 03:52:05

RE: Custom order for legend

Essential when using buckets! Hopefully coming soon :)

Krishna Sankar's profile image Profile Picture

Power BI User on 16 Aug 2020 03:52:05

RE: Custom order for legend

for all chart please!

Krishna Sankar's profile image Profile Picture

lenzy petty on 16 Aug 2020 03:52:05

RE: Custom order for legend

This is another example of a Power BI shortcoming that keeps sending me back to Tableau.

Krishna Sankar's profile image Profile Picture

Andy Youngblood on 16 Aug 2020 03:51:52

RE: Custom order for legend

This feature would be handy when reporting in terms of months, especially month-to-date reporting. Currently, I added an additional column and gave each month a numerical value (Jan-1, Feb-2, etc), and then hid the numerical column once sorted. This step is unnecessary and inefficient. Another option would be to include the numerical value in the name of the month ("1-January", "2-February", etc.). This option is redundant and aesthetically unpleasing. Just a thought!

Krishna Sankar's profile image Profile Picture

Power BI User on 16 Aug 2020 03:51:45

RE: Custom order for legend

One work-around is to name the items in the legend with an appropriate number of blank spaces, so that when Power BI alphabetizes them, the leading spaces determine the order. So your categories could be:
" Strongly Agree"
" Agree"
" Disagree"
"Strongly Disagree"

Krishna Sankar's profile image Profile Picture

E on 16 Aug 2020 03:51:39

RE: Custom order for legend

So much of this. As Anne said, sometimes we don't want it in alphabetical order...