Forum Discussion

luizronsani's avatar
luizronsani
Regular Visitor
6 years ago
Solved

Conditional formatting based on a measure and different criterias

Hello !

 

I have a table where the column "%" is a measure that is the percentage of incidentes that have met the target (Met/Count). There is different target number for each priority, for example: Critical is 95%, High is 90%...

 

 

The problem is that I can't do conditional formatting for different targets, green if greater and red if smaller. Is thare any way to do this?

 

Thanks in advance for any help.

Need Help
Tips and Tricks
  • MFelix's avatar
    MFelix
    6 years ago

    Hi luizronsani ,

     

    You can create a measure to make the formatting based on the % and the Priority something similar to the one below:

     

    Condittional Formatting = 
SWITCH (
    TRUE ();
    (
        SELECTEDVALUE ( 'Table'[Priority] ) = "Critical"
            && [%] >= 0,95
    ); "#75FF00";
    (
        SELECTEDVALUE ( 'Table'[Priority] ) = "Critical"
            && [%] < 0,95
    ); "#E66C37";
    (
        SELECTEDVALUE ( 'Table'[Priority] ) = "High"
            && [%] >= 0,90
    ); "#75FF00";
    (
        SELECTEDVALUE ( 'Table'[Priority] ) = "High"
            && [%] < 0,90
    ); "#E66C37"
)

    You just need to two lines for each of the priority and change the colours on the formaating to the ones you need, then use the field value on the conditional formatting..

     

    Check the result attach.

     

    Regards,

    MFelix

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    Hi luizronsani ,

     

    You can create a measure to make the formatting based on the % and the Priority something similar to the one below:

     

    Condittional Formatting = 
SWITCH (
    TRUE ();
    (
        SELECTEDVALUE ( 'Table'[Priority] ) = "Critical"
            && [%] >= 0,95
    ); "#75FF00";
    (
        SELECTEDVALUE ( 'Table'[Priority] ) = "Critical"
            && [%] < 0,95
    ); "#E66C37";
    (
        SELECTEDVALUE ( 'Table'[Priority] ) = "High"
            && [%] >= 0,90
    ); "#75FF00";
    (
        SELECTEDVALUE ( 'Table'[Priority] ) = "High"
            && [%] < 0,90
    ); "#E66C37"
)

    You just need to two lines for each of the priority and change the colours on the formaating to the ones you need, then use the field value on the conditional formatting..

     

    Check the result attach.

     

    Regards,

    MFelix