Custom order for legend in stacked bar chart
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
Rob Oesch commented
While we wait for this feature, has anyone figured a workaround? Other than changing the labels of course.
Yes orely needed i have three criteria labelled W, W- and W+ the W needs to be in the middle!
Huan Wang commented
this is the standard way to look at the data folks ~!
Stuart Charles commented
Come on Power BI team - this is very basic missing functionality!
We need to be able to stack Revenue in a given week, but we want the recognised revenue at the bottom and forecast at the top.
James Winegar commented
This is one of the items stopping me from switching to Power BI
Having a legend order matching the stacked bars value is a charting 101 issue. It has been Excel for decades. Please add this basic feature ASAP.
why isn't this a thing yet? incredibly frustrating to have to come up with work-arounds for something so basic!
Zac Tolfrey commented
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!
i found something, there are 3 dots in the top right corner of the chart, here you can change the order of the bars.
...so it's been over a year and MSFT still doesn't have a custom sort feature?
Jade Doherty commented
@N1c0l3 - thanks your workaround solution did the trick - but yes agree this should be a standard feature to allow custom sorting
Thiago Zaiden commented
This would be great for all charts!
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!
Does anyone have a quick workaround for this? Custom sort is a feature that is absolutely needed.
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.
100% agreed. Allows you to avoid having to create a date workout for custom date hierarchy structures.
This is a must.
Would be very useful, please add this feature!
I have the same issue. The Power BI Team needs to provide some method to manually select the legend order.
Yes custom sort order is absolutely essential! For instance I have categories Research, Analyze, Develop which should display in that order.