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.

jdbuchanan71's avatar
jdbuchanan71
Super User
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi jdbuchanan71 

     

    I really appreciate your help! I feel like I'm so close to solving this but I'm having a small issue.

     

    I've made the measure as required:

     

     

    It has then entered itself into the report as expected:

     

     

    But when applying the rule, the measure is Greyed out and not selectable:

     

     

    Do you know why this might be? I've tried putting the measure itself into the actual report instead of Diff, selecting it and de-selecting it etc to no avail.

     

    I'd really appreciate further guidance.

     

    Thank you jdbuchanan71