Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
6 years ago
Solved

undefined

I have three different KPI's for each of the Priority levels.  How can I set different conditional formatting for the results in a table.  See screen shots below.  This is how I would like it to show - 

 

Minor - Show RED font if greater than 170, Green otherwise

Major - Show RED font if greater than  72, Green otherwise

Critical - Show RED font if 24 greater than 24, green otherwise

 


Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi jcastr02 ,

    Please change your condition measure like so:

    Condition =
IF (
    MAX ( 'Table (3)'[Priority] ) = "Minor",
    IF ( AVERAGE ( 'Table (3)'[Value] ) > 170, 1, 0 ),
    IF (
        MAX ( 'Table (3)'[Priority] ) = "Major",
        IF ( AVERAGE ( 'Table (3)'[Value] ) > 72, 1, 0 ),
        IF (
            MAX ( 'Table (3)'[Priority] ) = "Critical",
            IF ( AVERAGE ( 'Table (3)'[Value] ) > 24, 1, 0 )
        )
    )
)

    This is because of your "average" value in matrix.

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

14 Replies

  • JosefPrakljacic's avatar
    JosefPrakljacic
    Solution Sage
    6 years ago

    Hey jcastr02,

     

    here you will find everything what you need for your request.

     

    If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others

    Have a nice day!

    BR,
    Josef
    Graz - Austria

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi jcastr02 ,

    You can create a measure like so:

    Condition =
IF (
    MAX ( 'Table (3)'[Priority] ) = "Minor",
    IF ( MAX ( 'Table (3)'[Value] ) > 170, 1, 0 ),
    IF (
        MAX ( 'Table (3)'[Priority] ) = "Major",
        IF ( MAX ( 'Table (3)'[Value] ) > 72, 1, 0 ),
        IF (
            MAX ( 'Table (3)'[Priority] ) = "Critical",
            IF ( MAX ( 'Table (3)'[Value] ) > 24, 1, 0 )
        )
    )
)

    And then, set conditional formatting.

     

    Best Regards,
    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • jcastr02's avatar
      jcastr02
      Post Prodigy
      6 years ago

      hello Icey 

       

      I added the measure and the conditional formatting.  One thing I notice is that I don't have the number field in the conditional formatting area.  Any ideas?  See screen shot below   **I ended up using the font color vs. background color, assumming this is the same process anyways**

       

       

      • Icey's avatar
        Icey
        Community Support
        6 years ago

        Hi jcastr02 ,

        Which version of your Power BI Desktop is it? Maybe you need to update it.

         

        Best Regards,

        Icey

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi jcastr02 ,

     

    Is this problem sloved?

     

    If it is sloved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    If not, please let me know.

     

    Best Regards
    Icey