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.

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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank v-diye-msft , I will look at that thread to get an idea about what I'm doing wrong although jdbuchanan71  had me soooo close to solving this thing.

     

    I know it's going to be something super simple too get this rectified but it's eluding me at the moment.

     

    Would you happen to know why the measure isn't selectable in the conditional formatting pane?

     

    Thank you

    • v-diye-msft's avatar
      v-diye-msft
      Community Support
      7 years ago

      Hi 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-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