How I can change color of specific row when it's different than other value

[Anonymous]

So i have two columns it look something like this:

5 12

3,4 3,4

12 9

And if i have other values in the same row i want to change background color to red.

Something like

5 12

3,4 3,4

12 9

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

1. create a measure like below.

Color format measure: = 
    IF( SUM(Data[Column1]) <> SUM(Data[Column2]), "Red")

2. each column, click down arrow, and then select Conditional formatting -> Background color

3. Select Format style = Field value

4. Select What field should we base this on? = the measure that is created above