Conditional Formatting of Bar Chart

[Anonymous]

I would like the bars that are below the target value to be red and those equal to or above target to be green.  I do not see the 'divergent' color bar options .. do I have an old version of the app?

 

[hamzahad91]

How can we go if the target is variable ?

[ThirdI]

@hamzahad91

Currently there is no way to format the column based on a variable value. Conditional formatting will only work for a hard coded value (Min/Max value).

[djroller1]

You can conditional format a column based on a wide range of values   For example, if I set my min color to red and min value to -1, then any column that has a numerical value less than -1 will show up as red.    Conversely, if I set my max color to green and my max value to 1, any column that has a value >1 will have a color of green.    This is assuming I have my numerical column field  in both the value well and the color saturation well.

[Vvelarde]

@Anonymous

Hi, The divergent option is show when you add a column or measure in Color Saturation.

[Anonymous]

Thank you ... I see it now.  Can you advise on how to dynamically change the color based on the target value?  If below 95 then red and if >=95 it should be green?

[Vvelarde · Accepted solution]

@Anonymous

[Anonymous]

Hi , Please explain it in detail , you only posted pic. I am not getting option.

---

@Vvelarde wrote:

@Anonymous

---

[Anonymous]

I got it by hovering over the area next to default color in data colors to get conditional formatting to appear.  It's not very intuitive.

[Anonymous]

How do you get these options to appear?  I don't see anything about divergent/conditional formatting for my charts.

[ThirdI]

Here's what you need to do to achieve this - 

There is an option in the Format pane called Data Color. When you expand the Data Color option, HOVER on the Default Color option and you will see three dots. Once you click on these dots, you will see the option of Conditional Formatting. Click on Conditional Formatting to see more options for formatting.

Click on Format Pane > Click on Data Color > Hover on Default Color and Click on three dots > Click on Conditional Formatting 

[bclrk]

@Anonymous @ThirdI I do not seem to have that option and I cannot figure out why. Nothing appears when I hover either.

[bclrk]

This problem was answered for me here:

https://community.powerbi.com/t5/Desktop/Conditional-formatting-not-available-on-column-chart/m-p/79...

[Kitt_Burch]

The "solution" seems to be "you can't do it," which is all too common in Power BI.

[Anonymous]

Hi Team,

I need my data bar to have only two colours. I have an average line. The value below average should have red and above should have green. When I apply the field in colour saturation and in 'Format' when I give color code for Minimum ans Maximum, I get bars in the middle with combination of both green and red, values above one are a gradient shade of green, and bars below one are shades of red. I don have any fixed value to be given as minimum and maximum as values changes dynamically with average line. 

Can you suggest a way to sort this. 

Thanks in advance. 

[djroller1]

Hi Crazybi,

Unfortunately, min and max can't be dynamic.   But you can create a separate chart based on a calculated column or measure that represents the difference between a data point and the average.   If I subtract the average from a data point, the results will always be positive if the data point is above the average, and alway negative if below.   You could tie these difference values to color bars using the max of 0 and min of -1.

I know this isn't the solution you are  looking for, but it might be usable as a supplemental visual to highlight above/below avg in a way that varies, even while the min/max values remain fixed.

[Anonymous]

Thanks! Hadn't thought of doing this yet - still working in 2019 😄

[Anonymous]

Thank you!  Got it .... I had the wrong field in the Color Saturation area. 

[Anonymous]

Thank you ... I see it now.  Can you advise on how to dynamically change the color based on the target value?  If below 95 then red and if >=95 it should be green?

[Anonymous]

I would like the bars that are below the target value to be red and those equal to or above target to be green.  I do not see the 'divergent' color bar options .. do I have an old version of the app?

[Anonymous]

I would like the bars that are below the target value to be red and those equal to or above target to be green.  I do not see the 'divergent' color bar options .. do I have an old version of the app?