Sort on legend in Stacked Area Chart Power Bi

Question

I am using Stack chart on Power BI, I have used Year as x-axis, Group as legend in my graph and % of Work Order as value. I have Sort order of group as well but struggling to sort legends based on Group Sort. Now Legends are not coming in sort order.

Answer 1

Just follow these below steps-

1. Go to the Model window and select the table
2. Now select your column Group
3. Finally, sort the column using column Group Short as shown in the sample image below-

This should order as per your requirement-