conditional formatting of bars

[daniel_krantz_4]

Wanted to make sure I'm not missing something. It doesn't seem like, when using bar charts, I have the option to set conditional formatting on the color of the bars based on the values (75%+ the bar is green, 40-75% bar is yellow, below 40% bar is red) if I put two variables in the x-axis (doing a horizontal bar chart).

Am I missing something or does powerbi not have that functionality?

[ray_aramburo]

Not natively (I mean a specific UI for bar conditional formatting) but you can create a measure and use it here:

Measure can be written like:

Bar_Color = IF([MeasureOfYourValues] < .40, "#FF0000", IF([MeasureOfYourValues] < .75, "#FFFF00", "#008000"))

Edit: I actually remembered you can still write the logic within that FX UI though 🙂

If you will use the measure one (I prefer that option as you can change anytime the colors faster), use the Field Value option and select the created measure from the dropdown:

[daniel_krantz_4]

Yea that fx thing isn't there when I add two variables to the stacked columns bar. 

[ray_aramburo · Accepted solution]

Ah, I thought it was the simple one. So, unfortunately, conditional formatting isn't available (yet) for stacked charts 😞