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 

Format cond MEP-Jour font (Date derniere MEP Planifie) =
var MEP_Planifie = Max(REF_PROJET[MEP Date])
var colorchange =
SWITCH(
    TRUE(),
     MEP_Planifie < [Date_jourM-1], "#E66C37","#000000"
  
)
RETURN
colorchange
 
Format cond %avancement = IF(
    [% Avancement projet] > 0.9, "#e66c37","#000000")
 
if both are "red "the nom du projet must be " blue"
 
 Thanks for your help
 

 

 

 

 

Need Help

3 Replies

  • 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:




       

       

       

  • 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")