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.

mkRabbani · Accepted Answer · 2020-10-19T07:28:24.897

1

Just follow these below steps-

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

This should order as per your requirement-

edited Oct 19 '20 at 07:28

answered Oct 19 '20 at 07:22

mkRabbani

16,295
2
15
24

Can you provide me the report file with sample data? – mkRabbani Oct 19 '20 at 08:03
How do I provide here? – Zeeshan shaikh Oct 19 '20 at 08:44
Keep the file in One or Google drive and share the link. – mkRabbani Oct 19 '20 at 09:13
https://drive.google.com/file/d/1jKccqcA8etqKoqSzslsN3Zjv0I_IRFeg/view?usp=sharing – Zeeshan shaikh Oct 19 '20 at 11:01
please check this – Zeeshan shaikh Oct 19 '20 at 11:01
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/223289/discussion-between-r-r-and-zeeshan-shaikh). – mkRabbani Oct 19 '20 at 12:27

Sort on legend in Stacked Area Chart Power Bi

1 Answers1

Linked