Legend order on the bar chart vs order on the legend

[Anonymous]

Currently the legend order on the bar chart is from bottom to top, but on the legend it is top to bottom. If you change the sort order, both of them switch.

(NOTE: this is not the standard custom sort order issue that @Anonymous replied on below - thanks).

There doesn't seem an obvious way to get them consistent: i.e. the order is from bottom to top on both the bar chart and the legend.

See below: yellow value is on the bottom of the bar chart but on the top of the legend!

Is there a solution to this? 

Thanks!

[Anonymous]

I've accomplished this by adding a new table for the relevent fields, creating a relationship between the tables and then use a simple DAX expression to sort by your new table. Check out this link, it explains things pretty well. https://www.seerinteractive.com/blog/reorder-powerbi-legend/

[Anonymous]

Hi @Anonymous 

Thanks for the post, however I don't think that is the solution. This is not a custom sort order issue - that's well documented elsewhere. 

This is that the sort order of the bar chart goes from bottom to top (Developing, Emerging+, Emerging, etc) starting with the light yellow section at the bottom, but the legend goes from top to bottom. 

I want the sections on the bar chart to match the order of the legend, so that the light yellow section on the bar chart is at the top and the legend labels also start with the light yellow blob at the top.

I've updated the original post to emphasise that.

[Anonymous]

Hi all,

I was wondering if anyone had a solution to this? I'm now thinking the only answer is a horizontal legend...

Thanks.