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
-
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?
-
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.
-
Cool! Dan here is the Formulate, i cant copy the text out as i'm using a VM
-
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
