You can try using something like the example I've attached... Here I assign a parameter value to drive my reference line (just place the parameter on the detail shelf to be able to use it as a ref line). Then use that same parameter in a calculated field on the measure you want to plot to create a new dimension indicating if the value is above or below that line. You can then use this new dimension to color the bars you plot differently.
Hope this helps,
Change Color over Ref Line.zip 952.2 KB
Good One Brad.
Is there a way to color only the bar chart above the reference line as green and retain the bar below line as blue ?
I don't think i understand your question. Right now only the bars above the line are colored green, while the ones below the line remain blue. Are you trying to do something different?
I suspect this will be impossible without having a dimension to split the bars apart by above or below the line. Additionally, this is not a good visualization practice. If you are trying to show which points exceded your reference line, the entire bar should be one color. When a bar is two colors, it suggests visually that the bar is composed to two parts instead of just being a single bar. If I saw a bar chart with the bars broken out as you want, I know I would be confused.
Just my two cents.
See the attached.
I used overlapping dual axis.
The one in the background shows the normal SUM(profit) while the one in the front shows the SUM(profit) truncated at the ref value.
While that is a nifty trick that I definitely would not have thought of, I will stand by my belief that this is a confusing view for users.
Cool find nonetheless Michel.
I'm with Dan on this one, I think it can be confusing. Especially if you are printing in B&W.
One question I have is, what exactly are you trying to highlight? One alternative would be to color the entire bars for those exceeding the ref line value. Another would be to have the measure for the bars be the variance from target value instead of from a 0 axis, so only those bars exceeding the value would be above the line and the rest would be below the line.
Excellent Michael !!!
Thanks for all the inputs Brad, Jonathan and Dan