Forum Discussion

lajthomas's avatar
lajthomas
New Member
8 years ago

Sort 100% Stacked Column Chart by Percentage Value

Hello,   Below is my 100% stacked chart.   How can I sort the legend based on the highest value of the column "1 - Réel". Actually the order is : 1 - Trad : 58% 2 - LS : 5% 3 - Surg : 3...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

For the Percentage, make sure the column type is Number in Power B. Select the column you want to sort, click Modeling > Sort by Column and then choose sort by Percentage. See if you can get the result you want.

 

 

 

  • lajthomas's avatar
    lajthomas
    New Member
    8 years ago

    Hello,

     

    Thanks for your reply.  But my data is different from what you presented.

     

     

     

    Above a screen shot of my data, I have slightly change the legend by removing "1, 2 and 3" in front of it.

     

    The percentage are calculated automatically.