Forum Discussion
Conditional Formatting of Bar Chart
Anonymous
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.
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
