Forum Discussion
Sort by legend on stacked bar chart
- Anonymous5 years ago
You can change the sort individually for a legend. However Power BI will pick up the sorting logic defined for the column in the data model. The default is alphbetical. To change it
1. you would need another sort column in your table i.e"sorting logic" (1,2,3...)
2. then set the sort setting for your column to sort by the column "sorting logic"
This will change the sort order for the column across the data model, hence also be applied to the legend.
Another quick fix: What you could do is change the value to add numbers that will change the sort. Example "1. Secured" "2. Potential"
- 5 years ago
I found this video on YouTube that really simplified the steps needed.
https://www.youtube.com/watch?v=4xapOrfLvbg
Thanks once again for your reply, put me on the right track.
You can change the sort individually for a legend. However Power BI will pick up the sorting logic defined for the column in the data model. The default is alphbetical. To change it
1. you would need another sort column in your table i.e"sorting logic" (1,2,3...)
2. then set the sort setting for your column to sort by the column "sorting logic"
This will change the sort order for the column across the data model, hence also be applied to the legend.
Another quick fix: What you could do is change the value to add numbers that will change the sort. Example "1. Secured" "2. Potential"