Data Colors for lenend not using theme order

[Anonymous]

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!

[amitchandak]

@Anonymous , As of now conditional formatting is not supported on visual with the legend. And this behavior is common.

You can create an idea or log a new one -https://ideas.powerbi.com/ideas/