In stacked bar chart custom color the bar values

[Anonymous]

Hi 

I have below chart, and want red to be green when postive value and red when negative value, how it can be achieved. thanks

[Anonymous · Accepted solution]

Hi @Anonymous ,

Because you use Legend, the stacked bar chart already distinguishes colors, and if you cancel Legend, you can add dynamic color formulas.

When there's a field in Legend, you can't use conditional formatting.

When there's no field in Legend, you can set up color dynamically which means using conditional formatting.

This means that if you use Legend, you can't use conditional formatting. I hope you understand.

As @amitchandak  said, if you want conditional formatting when using Legend, please submit this idea below.

 Ideas (powerbi.com)

Best Regards,

Stephen Tao

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

[Anonymous]

can you please give more detail on conditional formatting to set color, I am not able to find it. thanks

[amitchandak]

@Anonymous , I stacked visual you can set color for series but can use conditional formatting to set color

You can log and Idea -https://ideas.powerbi.com/ideas/