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"
- Saarek5 years ago
Helper III
Thanks Anonymous I had hoped that there would be a simple gui based option, but I'm finding that with Power BI a lot of really simple stuff seems to need work arounds to make it work.
Using your advice and piecing together other articles I've worked it out.
- Saarek5 years ago
Helper III
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.