Forum Discussion
Conditional Formatting based on Expressions
I cannot think a way yet to add a dynamic measure specially when it returns text or segments.
You can achieve the 3 color scale ( if the Profit Alert is not dynamic - meaning the between values are static ) if you pass these values to the format pane. You add the profit measure also in the saturation field/place and the in the formatting options of the chart ( suppose a bar - column chart ) under Data colors you Select Diverging ON and then add manually the values and colors of Min, Center, Max. The first two Min, Center must be the same number or really close if you need distinc colors. You can play around with the limits.
konstantinos, the method I usually use is to create a measure similar to what RishabhDhingra has made, but returning -1, 0, 1 based on the conditions required. Then the diverging colors can be set for those numbers. This is very similar to the KPI implementation in SSAS and Power Pivot.
greggyb Thanks..didn't thought that..This way can also be combined with dynamic target/limits..