Forum Discussion
Nested IF or ?
Hey, i am running into a problem when i need to make a conditional formatting setting, but i have 15 measures for each row in a table. I have tried the measure below, but it only works for the measur...
Robin96 Try using a SWITCH(TRUE(),...) statement instead of nested IF statements.
SWITCH(TRUE(),
serviceavtaler <= 1, "#FF0000",
servicevtaler > 0, "#008000",
<next condition>, <next value>,
...,
<default value>
)Hey Greg_Deckler
I tried your solution, but it looks like the first condition is met in the first row, so it applies that expression to the whole table. i am trying something like this without any luck:i want it to change color based on the value in the row level. Here is a picture of the measure for the table Is there any way to color format in here??:
Robin96 Right, the first condition that is met is what is returned. Note, that would be similar to nested IF statemetns. So, you will need additional conditions perhaps using && or something else to distinguish what things get what colors. Hard to say more as I don't know all the business rules.
