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
bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

fbittencourt ,Create a new measure or column for the "Nom du projet" font color.

 

Format cond Nom du projet =
VAR MEP_Planifie = MAX(REF_PROJET[MEP Date])
VAR colorMEP = IF(MEP_Planifie < [Date_jourM-1], "#E66C37", "#000000")
VAR colorProgress = IF([% Avancement projet] > 0.9, "#E66C37", "#000000")
RETURN
SWITCH(
TRUE(),
colorMEP = "#E66C37" && colorProgress = "#E66C37", "#0000FF", // Both conditions are red, set to blue
colorMEP = "#E66C37", "#E66C37", // MEP condition is red
colorProgress = "#E66C37", "#E66C37", // Progress condition is red
"#000000" // Default color
)

  • fbittencourt's avatar
    fbittencourt
    Helper IV
    1 year ago

    Thanks for your quick answer !! I will acceptt as a solution.

     

    I have a small issue concerning blank values, if you are to hepl me again I appreciate, the condition applies as well with blank date values see below: