Search code examples
sortingpowerbidaxstacked-area-chart

Sort on legend in Stacked Area Chart Power Bi


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.

enter image description here

enter image description here


Solution

  • 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-

    enter image description here