Change row color in Matrix by comparing the columns' values

[MinhPham96]

Hello, so I have the following Matrix, I have two columns Forecast and Achieved. What I want is that for each row, if Achieved is >= 70% of Forecast, that row will be colored Green; else the row color will be red. I am fairly new to this so I hope I can get some help. Thank you for reading.

[MinhPham96]

Hello @v-lili6-msft , thank you for your answer, but in my case, it is a bit different, here is how my table look like 

And this is how it is presented in the matrix 

So when I decided to do conditional formatting, I have something like this, which I cannot use.

Can you have a look for me, thank you very much. 

[v-lili6-msft · Accepted solution]

hi, @MinhPham96 

If so, just adjust it as below:

Step1:

Create a measure as below:

Measure = IF(CALCULATE(SUM('Table'[Actual Amount]))>=CALCULATE(SUM('Table'[Forecast Amount]))*0.7,1,2)

Step2:

Create conditional format as below:

and for your case, you need to do conditional format for each field in Values

and here is new sample pbix file, please try it.

Regards,

Lin

[v-lili6-msft]

HI, @MinhPham96 

You could try this way as below:

Step1:

Create a measure by this logic:

Measure = IF(CALCULATE(SUM('Table'[Value]),'Table'[Type]="Achieved")>=CALCULATE(SUM('Table'[Value]),'Table'[Type]="Forecast")*0.7,1,2)

Step3:

Then use Conditional formatting in power bi as below:

Result:

and here is sample pbix file, please try it.

Regards,

Lin