Forum Discussion
Conditional Formatting based on Expressions
Hi All,
I have created a measure for Profit Alert which says if Profit is between ... and ... then "Ok", between .... and .... "Warning" else "Low". Now I have a bar chart against the Region di...
greggyb
Resident Rockstar
Resident Rockstarkonstantinos, 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.
konstantinos
Memorable Member
Memorable Membergreggyb Thanks..didn't thought that..This way can also be combined with dynamic target/limits..