Pie Chart Legend not sorting properly

[Mizzi1234]

I'm confused why I cant get the legend to sort properly.

the posts that i've looked at indicate that you need to make a sort order column but considering that my fields are already numbers I don't think a sort column will actually help the problem.

[Mizzi1234 · Accepted solution]

So i figured out the problem was that the chart sorting the wrong column.

for anyone having the same issue as me, click on the 3 dots at the top right of the chart and change the "sort axis" to your legend field.

i'm not sure why you can't sort a chart through the actual visualization or filter pane which is where you would think this kind of option would be but at least i found the hidden button.

[dharmendars007]

Hello @Mizzi1234 , 

While your "Expected Ship" values are numbers, Power BI may still need an explicit sort order. Create a calculated column to ensure that Power BI knows how to sort these values. You can add a column with the same values, but explicitly set the sorting order by selecting the "SORTBYCOLUMN" Option inside Dataview in Power BI.

If you find this helpful , please mark it as solution and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN