Color formatting with 3 conditions

Anonymous — Thu, 22 Dec 2022 10:42:53 GMT

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

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.

Re: Color formatting with 3 conditions

Mahesh0016 — Thu, 22 Dec 2022 10:47:57 GMT

can you share sample output in table format?

Re: Color formatting with 3 conditions

Mahesh0016 — Thu, 22 Dec 2022 11:11:28 GMT

#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.

topic Color formatting with 3 conditions in DAX Commands and Tips

Color formatting with 3 conditions

Re: Color formatting with 3 conditions

Re: Color formatting with 3 conditions