Conditional Formatting of Bar Chart

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.