Forum Discussion
Sort the legend order by count?
Hi all,
I've been trying to sort the legend order by the count but couldn't find any option.
I know that I can do that with the static numbers, for example set the order 1 2 3 etc. and sort the legend column based on that (sort by another column), but in this case, the count can change and I want the legend order to be sorted with the count as well.
Is there any way to do so?
The count is a measure btw.
This is an example as you can see the legends are sorted alphabatically, not by the count and there's no option under that 3dots menu.
Thanks,
k3rz0rg.
2 Replies
- amitchandak
Super User
k3rz0rg , There is an option added for that in nov 2021, but you can not still sort on value.
Log an idea for that https://ideas.powerbi.com/ideas/
- k3rz0rg
Advocate III
amitchandak Yes I noticed, but it's a bummer that we can't do that by count (if it's not there yet)! It is one of the frequently asked things to me in my company and I just keep them in loop of hope! 😕