Help with stacked bar chart - editing legend order

[Anonymous]

I followed these instructions on an old post to create a stacked bar chart (thanks @Sean!)

However, now the legend is listed alphabetically, and I need it to be in order of 'agreement' (ie strongly disagree, disagree, neither agree nor disagree, agree, strongly agree)

Can anyone help with this?

[v-lili6-msft · Accepted solution]

hi  @Anonymous 

By the way, you'd better add a custom sort column in power query after unpivot the column. Then sort by column as above solution.

Regards,

Lin

[amitchandak]

@Anonymous , refer https://community.powerbi.com/t5/Desktop/Order-for-legends-in-stacked-bar-charts/m-p/1160424

https://community.powerbi.com/t5/Desktop/stacked-column-chart-legend-order/m-p/427810

[parry2k]

@Anonymous you should sort the legend using sort by column technique described here

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡