Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hi
i want to show - values in green color nd +ve values in red color
what is the condition i need to use in font color conditional formatting.
Solved! Go to Solution.
@Anonymous
If you want to apply a conditional formatting on the field in a table or matrix you can do it directly though table options instead of creating a new field.
See image below. It is a rule based formatting
@Anonymous , You can try rule base
like
-100 to 0 (absolute value, assuming this % column] red
0 to 100 , green
Or a color measure
color = if([chnage%] <= 0, "Red", "Green")
use that in conditional formatting using field value option