Sort 100% Stacked Column Chart by Percentage Value

[lajthomas]

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.

[v-piga-msft]

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]

Hello Cherry,

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

[Anonymous]

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]

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.