1

Background Colour cells based on IF formula

As per the above, I have created an IF formula to specify what colour I want the cell to be, based on the value of the measure.  This doesnt seem to work no matter what I try when dragging the formulated measure into 'background'.  It works with 'foreground/indicators' and colours the value accordingly but I ideally wanted it to colour the entire cell background instead.  Is there a way to do this without using indicators/foreground colour options?

Attached is the workaround I currently have in place.

Thanks,

Dan

4 replies

null
    • Adam_Taylor
    • 3 yrs ago
    • Reported - view

    Hi Dan i've done similar with hard coded values using a Case statement instead of IF, and dragged it onto colour under Background Custom Colours, it shaded the entire cells is this what you mean?

    • "making the sophisticated simple"
    • AviPerez
    • 3 yrs ago
    • Reported - view

    Adam is correct - although IF will work too. The critical part is to generate color values in the formula and drive "custom colors" on the background color sub-drop zone. If you want a more simplistic handling of the data, use one of the other algorithms on the background colors.

     

    See help for this. (also here)

    • Adam_Taylor
    • 3 yrs ago
    • Reported - view

    Cool! Dan here is the Formulate, i cant copy the text out as i'm using a VM 

    • Sergio_Galimberti
    • 3 yrs ago
    • Reported - view

    Hello Dan, in Formulate I use the foreground/background color option.

    example: iif([Measures].CurrentMember < 0.00,16092,0)  ---> this script write the measure in red if lower than 0 and in black in the other cases.

    In Discovery report activate "Model colors" check.

    hope this help

Content aside

  • Status Answered
  • 1 Likes
  • 3 yrs agoLast active
  • 4Replies
  • 41Views
  • 4 Following