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(),
    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)"))
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.

8 Replies

  • 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.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    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's avatar
    Anonymous
    Not applicable
    6 years ago

    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'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.