Forum Discussion
Anonymous
5 years agoNot applicable
font color conditional formatting
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.
- Anonymous5 years agoHello Anonymous,Create a measure like this and use in conditional formatting.Measure = IF(MAXX(Sheet1,Sheet1[percent])<0,"#73B761","#de6a73")
3 Replies
- amitchandakSuper User
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
- AnonymousNot applicableHello Anonymous,Create a measure like this and use in conditional formatting.Measure = IF(MAXX(Sheet1,Sheet1[percent])<0,"#73B761","#de6a73")
- themistoklisCommunity Champion
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