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 (343)
RE: Custom order for legend
Absolutely needed. And while you are at it, please also allow to define a custom color for each value in a dimension that is then used in bar charts on the legend, throughout the report, without having to adjust each visual. Thanks,Robert
RE: Custom order for legend
This is extremely important, I have reports I can't move into powerbi cause I can't order the buckets in the legend and the seemingly random chosen isn't readable.
RE: Custom order for legend
push!highly requested feature from our departments
RE: Custom order for legend
Sort by value please!! Small multiples already has that feature, why not legend?
RE: Custom order for legend
Agree, desperately needed.
RE: Custom order for legend
Bump. This is desperately needed.
RE: Custom order for legend
The related suggestion for correcting the default sort order needs more votes, for those who are interested: https://ideas.powerbi.com/ideas/idea/?ideaid=b1363cc1-0810-462d-8801-0e64973751c7
RE: Custom order for legend
The legend should be in the same order as the stacked bar charts as default. No one wants them in opposite order, it is confusing for the reader and therefore bad practice. Why was it programmed this way in the first place?
RE: Custom order for legend
I always use this trick (or almost something like this)
https://www.youtube.com/watch?v=uZLmWz60_do
Had always worked correct for me
RE: Custom order for legend
Hi,
It will be great to have this feature indeed.
As a workaround I use the custom conditional columns.
You insert a new conditional column in the data table (I called it order by)
Assign a number for each value in the desired column(column A) for which you want to assign the custom order. If you have 10 values you want to put in specific order you use the number from 1 to 10.
Make sure your new column is with data type Number. Then close & apply the changes,
Select the column (Column A) to which you want to apply custom order,
Once you select the (Column A) on the top new tab Column tools will appear
Select sort by and select the new column with the assigned number for the values in your column
It works well for me as a workaround to sort and order everything the way I want to. The downside is that it is manually maintained.
Hope that helps,
Best regards,
Nedelina