Customize colors for both legend and axis labels in Stacked column chart

[PSEJR]

Hi,

I am working on a stacked column chart, where I want to customize the colors based on both the legend information and the x-axis information. Here is as far as I've come:

As you can see I have the x-axis split in Budget/Forecast by Month, and in the legend I have "Nature of spending":

What I would like to do, is have the colors be different for Budget and Forecast. It's not very obvious in the current layout, that it's two different columns per month. But I can only speficify the color based on the legend:

Any ideas on how to do this? - Without having to pay for a custom visual developed by third party?

[V-lianl-msft]

Hi @PSEJR ,

As @parry2k  said,you may vote for these idea:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/38616598-data-colors-conditional-... 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20328412-color-scale-legend 

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

[parry2k · Accepted solution]

@PSEJR I don't think it is possible at this point to add conditional formatting when you are using legend. Look for an idea on ideas forum and vote for it.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!