Forum Discussion
Reording Legend in Clustered Column Chart
Hi,
I am trying to reorder the legend in the below clustered column chart to show AA, A, B, C & D opposed to alphabetically in the below. (Basically AA is better that A so needs to be at the top)
The chart is showing the count of each Contract Class (AA, A, B, C & D) by each country.
Any help would be greatfully recived, in layman terms if possible as I am teaching myself and am not technical at all.
Thank you.
4 Replies
- Greg_Deckler
Community Champion
EmmaLynch - Try creating a "Sort by" column for your legend that has the right sort order. https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
- amitchandak
Super User
EmmaLynch , the legend will sort alphabetically unless you change that by sort column
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Hi
Thanks for your response - I have added a Contract Class Order column but when I try to sort contract class by this column I get an error message "This column cant be sorted by a column that is already sorted directly or indirectly by this column" - I have no idea what this means ? Any idea ?
Hi EmmaLynch,
Please refer to following blog to create a custom sort table to set sort order and link to original table field and use on visual to enable the custom sort effect:
Regards,
Xiaoxin Sheng
