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 (345)
RE: Custom order for legend
Strongly agreed.
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.
RE: Custom order for legend
Definitely needed!
RE: Custom order for legend
Yea, for all charts please!
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.
RE: Custom order for legend
Essential when using buckets! Hopefully coming soon :)
RE: Custom order for legend
for all chart please!
RE: Custom order for legend
This is another example of a Power BI shortcoming that keeps sending me back to Tableau.
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!
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"