Forum Discussion
Conditional Formatting based on calculated column inc + and - returned results
Hello I'm trying to change the background colour of a cell which is a returned result of a calculated column based on data from two other columns. Background: I have a column of scheduled arr...
Anonymous
You can write a measure that you will use just to format your text.
Format Measure = MAX ( 'Table'[Diff] )
Then in the conditional formatting you apply the rules to that field.
v-diye-msft
Community Support
Community SupportHi Anonymous ,
It's unselectable in my side either, he should prabably add the calculated column rather than measure. that I'd like to suggest you add the format measure and then applied it to values measure. and the formula won't be very complicated. you can refer to the second part of my solved cases above.
Best regards,
Dina Ye
v-diye-msftCommunity Support
Community SupportHi Anonymous ,
It seems i happen to know the point, what's the data type of your measure? it does work when I use whole number, but failed to use non-number type.
Best regards,
Dina Ye