Conditional formatting based on a measure and different criterias

[luizronsani]

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.

[MFelix · Accepted solution]

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

[luizronsani]

Thank you very much @MFelix! It worked perfectly! Regards, Luiz