Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Color formatting with 3 conditions

Hello,

 

I need to apply the formatting background of column 2 in Table visual with 3 different conditions : 

 

Column 1Column 2Column 3Column 4
4238
5742
4422
    

Condition 1 : Column 2 = Column 1  : no color

Condition 2 : Column 2 > Column 1 : Red

Condition : Column 3 > Column 4 : Orange

 

Thank you in advance.

 

Need Help
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago

    #Measures :

    _BGColor1 =
     VAR col1 = SELECTEDVALUE('conditional Formatting'[Column1])
     VAR col2 = SELECTEDVALUE('conditional Formatting'[Column2])
     VAR col3 = SELECTEDVALUE('conditional Formatting'[Column3])
     VAR col4 = SELECTEDVALUE('conditional Formatting'[Column4])

     RETURN
     IF(col2=col1,"#0000FF","Yellow")
     
    #Measure_2 :
    _BGColor2 =
     VAR col1 = SELECTEDVALUE('conditional Formatting'[Column1])
     VAR col2 = SELECTEDVALUE('conditional Formatting'[Column2])
     VAR col3 = SELECTEDVALUE('conditional Formatting'[Column3])
     VAR col4 = SELECTEDVALUE('conditional Formatting'[Column4])

     RETURN
     IF(col2>col1,"RED","Yellow")
     
    #Measure_3 :
    _BGColor3 =
     VAR col1 = SELECTEDVALUE('conditional Formatting'[Column1])
     VAR col2 = SELECTEDVALUE('conditional Formatting'[Column2])
     VAR col3 = SELECTEDVALUE('conditional Formatting'[Column3])
     VAR col4 = SELECTEDVALUE('conditional Formatting'[Column4])

     RETURN
     IF(col3>col4,"Orange","Yellow")
     
    #Measure_4 : 
    _BGColor4 =
     VAR col1 = SELECTEDVALUE('conditional Formatting'[Column1])
     VAR col2 = SELECTEDVALUE('conditional Formatting'[Column2])
     VAR col3 = SELECTEDVALUE('conditional Formatting'[Column3])
     VAR col4 = SELECTEDVALUE('conditional Formatting'[Column4])

     RETURN
     IF(col2>col1,"#00FFFF","Yellow")
    If this post helps, please consider accept as solution to help other members find it more quickly.

2 Replies

  • Mahesh0016's avatar
    Mahesh0016
    Icon for Super User rankSuper User
    3 years ago

    #Measures :

    _BGColor1 =
     VAR col1 = SELECTEDVALUE('conditional Formatting'[Column1])
     VAR col2 = SELECTEDVALUE('conditional Formatting'[Column2])
     VAR col3 = SELECTEDVALUE('conditional Formatting'[Column3])
     VAR col4 = SELECTEDVALUE('conditional Formatting'[Column4])

     RETURN
     IF(col2=col1,"#0000FF","Yellow")
     
    #Measure_2 :
    _BGColor2 =
     VAR col1 = SELECTEDVALUE('conditional Formatting'[Column1])
     VAR col2 = SELECTEDVALUE('conditional Formatting'[Column2])
     VAR col3 = SELECTEDVALUE('conditional Formatting'[Column3])
     VAR col4 = SELECTEDVALUE('conditional Formatting'[Column4])

     RETURN
     IF(col2>col1,"RED","Yellow")
     
    #Measure_3 :
    _BGColor3 =
     VAR col1 = SELECTEDVALUE('conditional Formatting'[Column1])
     VAR col2 = SELECTEDVALUE('conditional Formatting'[Column2])
     VAR col3 = SELECTEDVALUE('conditional Formatting'[Column3])
     VAR col4 = SELECTEDVALUE('conditional Formatting'[Column4])

     RETURN
     IF(col3>col4,"Orange","Yellow")
     
    #Measure_4 : 
    _BGColor4 =
     VAR col1 = SELECTEDVALUE('conditional Formatting'[Column1])
     VAR col2 = SELECTEDVALUE('conditional Formatting'[Column2])
     VAR col3 = SELECTEDVALUE('conditional Formatting'[Column3])
     VAR col4 = SELECTEDVALUE('conditional Formatting'[Column4])

     RETURN
     IF(col2>col1,"#00FFFF","Yellow")
    If this post helps, please consider accept as solution to help other members find it more quickly.