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 1 Column 2 Column 3 Column 4 4 2 3 8 5 7 4 2 4 4 2 2...
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.
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.