Conditional Formatting - on live connection

[Anonymous]

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(),
    SummaryItem = "EMEA", FORMAT([EMEA Revenue vAOP$ 2],"#,##0.0%;(#,##0.0%)"),
    SummaryItem = "Americas", FORMAT([Americas Revenue vAOP$ 2],"#,##0.0%;(#,##0.0%)"),
    SummaryItem = "APAC", FORMAT([APAC Revenue vAOP$ 2],"#,##0.0%;(#,##0.0%)"),
    SummaryItem = "IDIS", FORMAT([ID & IS Revenue vAOP$ 2],"#,##0.0%;(#,##0.0%)"),
    SummaryItem = "Total", FORMAT([$NSvPY4% (NOE @ AOP Rate)],"#,##0.0%;(#,##0.0%)"),
        ISBLANK(SummaryItem),FORMAT(0.0,"$#,##0.0;($#,##0.0)"))

[Anonymous]

I am also experiencing a similar problem. I am connecting with the PowerBI dataset via Live connection and cant use conditional formatting on the text of any object via dax measure.

[Anonymous]

@Anonymous Did you find a asolution for this problem?

[Anonymous]

@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]

@Anonymous That did the trick. Thank you!

[v-yulgu-msft]

Hi @Anonymous,

What is your data source? I tested with live connection to SQL Server DB and SSAS Multidimensional model, conditional formatting option is available in both scenario.

Would you please post a screenshot? And update your Power BI desktop for a test.

Regards,

Yuliana Gu 

[Anonymous · Accepted solution]

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]

Hi Jeltex

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

[Anonymous]

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.