Data Colors for lenend not using theme order

Hi all

I have a theme with colors 1-8.

I have a sales table containing:

[Company] [Job Type] [Sales Amount]

I have 50 Job Types.

When I do a stacked column chart with Axis: Company, Legend: Job Type, Values: Sales Amount,

Then the data colors of the legend (Job Types) seems super random. I want my "biggest value Job Type" to be Color 1 and so forth.

I have tried to do a rankx based on Sales amount to rank the biggest job type, and sorted column by that new custom ranking column. Still doesnt work. 

I often have a lot of struggle with the legend data colors not following my theme?

Thanks!