How do I re-order stacked bars to a custom order?

[925stuart]

Hi,

My bars are now plotted alphabetically.  How do I re-order it to a custom order?  E.g. I want the green chunk to be at the bottom and not where it is just because the label starts with S.  Is that possible?

[Awmium]

Add a custom column with the desired sorting sequence, 

Next, select column1 and sort it by the custom from the ribbon.

[925stuart]

Thanks @Awmium but how do I translate that into the re-ordering of the stacked bars?

[Awmium]

It should've been solved by its own once you sort the column.

[925stuart]

Thanks but I'm not following.  😓

[Fowmy]

@925stuart 

To apply a custom sort to your legend, you need to create a custom column and use Sort By column option, you can do it in Power Query or in the source system and and sort the ledgend field by the new sort column. This should solve your problem.

[925stuart]

Do you mean transform Orange to 1.Orange so it displays before 2.Apples?

[Fowmy]

yes 

[925stuart]

I was trying to avoid doing it this way.  Is there another possibility?  Thanks!  @Fowmy 

[Fowmy]

@925stuart 

That is the workaround that I think of.