Forum Discussion
Conditional Formatting of Bar Chart
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
How do you get these options to appear? I don't see anything about divergent/conditional formatting for my charts.
- 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
Thank you! Got it .... I had the wrong field in the Color Saturation area.
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.
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.
Thanks! Hadn't thought of doing this yet - still working in 2019 :D
Hi , Please explain it in detail , you only posted pic. I am not getting option.
Vvelarde wrote: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.
