Forum Discussion
Legend Custom Sort isn't working
I have been trying to custom sort my legend for a while now as there was originally only a sort by ascending or discending option which doesn't fit what I am trying to do. I have created an extra column in my data called Order which should create a custom sort for my legend. Sort by column order has also been selected and there has been no changes made to the bar graph.
I have attached images to show what has been done, any fixes for this issue would be greatly appreciated.
This is the order I am afterThis is the current order.
3 Replies
Hi Anonymous,
This seems to be an issue that a lot of people are facing. In some cases, it happens in a specific visual while in other cases it can be resolved by changing the data type of sort column to whole number. Either way, this link has steps that you can perform to try and troubleshoot. Refer:
https://community.powerbi.com/t5/Desktop/Sort-by-column-not-working/td-p/1444819
Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Graphical ComparisonThank you for responding Shaurya
The data type of sort column was already set as whole number and unfortunately the outcome still remains the same.
Hi Anonymous ,
Currently, it is not possible to sort the legends, please vote for this idea.
One workaround is to add "1-", "2-",... before the field as a legend, It's not pretty, but it's useful.😓
est Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
