Forum Discussion

fbittencourt's avatar
fbittencourt
Helper IV
1 year ago

Color condition based on two variables

Hi all !!   I need to change the font color of  the column Nom du projet, based on two others columns Date derniere MEP Planifie and % Avancement projet  Each one has already a color condition  ...
Need Help
Bibiano_Geraldo's avatar
Bibiano_Geraldo
Super User
1 year ago

Hi fbittencourt ,

Please adapt your DAX to look like this:

Format cond Nom du projet = 
VAR MEP_Planifie = MAX(REF_PROJET[MEP Date])
VAR Avancement = MAX(REF_PROJET[% Avancement projet])

-- Check the color conditions for Date derniere MEP Planifie
VAR Color_MEP = IF(MEP_Planifie < [Date_jourM-1], "#E66C37", "#000000")

-- Check the color conditions for % Avancement projet
VAR Color_Avancement = IF(Avancement > 0.9, "#E66C37", "#000000")

-- If both are red, set the color to blue, otherwise keep the respective color
RETURN 
    IF(Color_MEP = "#E66C37" && Color_Avancement = "#E66C37", "#0000FF", "#000000")