Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Conditional Formatting - on live connection

Hi Experts   I cannot get the resuts of the following dax to show the negative numbers as red........   vAOP$ = VAR SummaryItem = SELECTEDVALUE( 'Templates'[Summary 1] ) Return SWITCH(TRUE(...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hello again,

     

    You have to add this measure:

    vAOP$_Color = 
SWITCH(TRUE(), 
[vAOP$] <0, "#ff0000",
BLANK())

    Then you need to do the following steps:

     

    Hope that this works!

    Kind Regards,

     

    EDIT: I see that i picked Background color instead of Font color by conditional formatting.

    This should be Font color.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous Did you find a asolution for this problem?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous  I think I was missing a simple step. After creating a measure, change the datatype of measure to text. Cause by default it was Number and that's why couldn't be used.

I hope that will solve your problem too.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous That did the trick. Thank you!