Change sort order of Legends made by metrics in a stacked column chart

[Power_Krille]

Hi

I have made 7 metrics that i just inserted in a stacked column chart and the bars has the right sortorder, but how do i change the sortorder of the legends. I want the legends mirror the sortorder of the bars. 

I have tried to invert the Y axis but it doesn´t look so nice then;

Is this possible to fix?

[Anonymous]

Hi  @Power_Krille ,

I created some data:

The visual objects presented are:

Custom rules:

I want to sort in reverse order

Here are the steps you can follow：

1. Enter the power query, click Table, and then click Copy to form New.

2. Click the remaining two columns, right-click, and select Remove Columns.

3. Click on the only column [group], and click Remove Duplicates.

4. Click Add Column – Colun From Examples – From ALL Columns.

Assign values in the order you want, here is the reverse order

5. Form New Table, click [group] column, Column tools – Sort by column – [Custom]

6. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Power_Krille]

Hi

Yes but that didn´t help because then the order of the bars was changed, now you can see that A is in the top of the bar, it should be in the bottom as it was in your first picture. I don´t want that the order of the bar should change only the legend.

[Power_Krille]

Hi

That was a quick reply.... :-), but i don´t have that option and i think that is because i don´t have legend set;

So that will not work for me. 

[amitchandak]

@Power_Krille , From nov 2021, onward there is an option given

https://powerbi.microsoft.com/en-us/blog/power-bi-november-2021-feature-summary/#post-17912-_Toc8747...

a legend sort can also be changed using a sort column