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 20 Aug 2020 01:24:03
Thanks for the feedback. Vote to keep updated on progress for this item.
- Comments (279)
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.
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.
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
RE: Custom order for legend
This would be great for all charts!
RE: Custom order for legend
Does anyone have a quick workaround for this? Custom sort is a feature that is absolutely needed.
RE: Custom order for legend
Quick workaround: since it's sorted alphabetically, rename the data to have some number of spaces before it. "__legend1" "_legend2" "legend3" will sort as desired. Legend displayed at top of page strips preceding spaces, but the desired sort is achieved!
RE: Custom order for legend
I tried to solve this issue by creating a table with Legend elements in a column and another column, and then ordering elements in Legend by other column, but I defined that column in terms of the Legend column (CALCULATE, ALLEXCEPT AND SUM), so Power BI refused to change the Sort (thus avoiding some sort of loop). Having this feature would definitely make it easier.
RE: Custom order for legend
100% agreed. Allows you to avoid having to create a date workout for custom date hierarchy structures.
RE: Custom order for legend
This is a must.
RE: Custom order for legend
waterfall charts currently only sort by category. Need to have the ability to sort by the measure, as is present in column reports.