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
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
7 years ago

Hi Jeltex

 

my connection into Power Bi is a Live Connection that option os disabled.....

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Is it possible to use conditional formatting on any value or is it disabled at your whole report?

    Never used live connections before so I don't really know.

     

    If it is disabled I don't think that it is possible right now.

    You might want to create a new idea at this link.