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 : 38%

 

I want it to be :

1 - Trad : 58%

3 - Surg : 38%

2 - LS : 5%

 

I do not want the sorting to be done manually, but automatically based on the highest percentage.

 

Thanks a lot for your help.

Need Help

4 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi lajthomas,

     

    From your description , it seems that you want to sort by the legend.

     

    By my tests, this feature is not supported currently in Power BI Desktop. 

     

    You could vote this similar idea here which has been submitted in Power BI ideas forum.

     

     

    Best Regards,

    Cherry

    • lajthomas's avatar
      lajthomas
      New Member
      8 years ago

      Hello Cherry,

       

      I don't know if your solution is the best, but I voted for it.

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