Matrix Condition Format Base On Diagonal

[hanhks]

I have a matrix summary check same item from 2 people. Each person has result difference with other. I make matrix compare results from them. I want to make matrix like below. Please help me, It's posible in Power BI.

Maxtrix compare 2 results

[v-juanli-msft · Accepted solution]

Hi @hanhks

Look at my test

in query editor, add two conditional columns

Then create a measure

Measure = IF(MAX([Custom1])>MAX([Custom2]),1,IF(MAX([Custom1])=MAX([Custom2]),0,-1))

Best Regards

Maggie

[hanhks]

@v-juanli-msft

I tested by your guide and it's OK. Very nice. Thank you.

[Phil_Seamark]

HI @hanhks

What is the rule that determines the colours?

[hanhks]

My expectation is cell postion (not cell value) under the diagonal line will fill blue (meaning better) and cell position upper diagonal will red color.