Forum Discussion
Conditional formatting working partially !!!
HI Louis66 ,
So in that case you need to modify your measure. Use SUM(Data[Returns]) in your condition in the measure.
You won't need a SELECTEDVALUE there. You can write your measure something like following:
Color = VAR returns_value = SUM ( Data[Returns] ) // total value of the value used RETURN SWITCH ( TRUE (), returns_value < 0, "#FF0000", // hexcode for Red color "#0000FF" // hexcode for Blue color )I just wrote the DAX above on the fly, so check if there are any syntax errors.
Hello Pragati, yes this is a measure I created, and yes I did use SUM for my returns... this is the screen shot.
... and my data :
It is the first time I have that kind of problem...
Louis
HI Louis66 ,
So in that case you need to modify your measure. Use SUM(Data[Returns]) in your condition in the measure.
You won't need a SELECTEDVALUE there. You can write your measure something like following:
Color =
VAR returns_value = SUM ( Data[Returns] ) // total value of the value used
RETURN
SWITCH (
TRUE (),
returns_value < 0, "#FF0000", // hexcode for Red color
"#0000FF" // hexcode for Blue color
)I just wrote the DAX above on the fly, so check if there are any syntax errors.