Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
Show and Tell
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    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's avatar
v-diye-msft
Community Support
7 years ago

Hi 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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

jdbuchanan71  v-diye-msft 

 

You two are the best!!!!

 

Thank you so much!

 

This is now solved so I will mark as complete.