Sort legend for stacked column chart

[Gerri]

I'm trying to sort the legend by a custom order and looked at past tutorials to create the sort table and sort index.

But when I try to sort the legend for the stacked chart, it still sorts the legend by alphabetical order.

Am I missing a step somewhere?

Sample data and the stacked chart:

Relationships between the tables:

Table sorted by column sort order:

[v-jayw-msft · Accepted solution]

Hi @Gerri ,

Add the sort order column to tooltip field, then you should be able to sort the visual by that column.

Best Regards,

Jay

[Gerri]

Sorted! Thanks for your help!

[mohammedadnant]

Hi @Gerri 

You need to use the feature of SORT BY COLUMN, pls see below image

Thanks & Regards,

Mohammed Adnan

Learn Power BI: https://www.youtube.com/c/taik18

[Gerri]

Hi @mohammedadnant ,

I did use SORT BY COLUMN but it doesn't affect the visual.

[mohammedadnant]

Hi @Gerri 

Can you try to select ascending/descending in the legend of this visual

Thanks & Regards,

Mohammed Adnan

Learn Power BI: https://www.youtube.com/c/taik18

[Gerri]

Hi @mohammedadnant ,

With the legend of this visual selected:

With the legend of this visual not selected:

The strange thing is that I have no problems with the legend if it was a pie chart..

[Gerri]

Hi @mohammedadnant ,

Is there any solution for the visual to sort by the custom sort order? I've tried rebuilding my visual but the legend won't sort by the custom order if it's a column chart..

[mohammedadnant]

Hi @Gerri 

Please share the sample to test.

Thanks & Regards,

Mohammed Adnan