Forum Discussion

hanhks's avatar
hanhks
Frequent Visitor
8 years ago
Solved

Matrix Condition Format Base On Diagonal

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 po...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    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

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

HI hanhks

 

What is the rule that determines the colours?

hanhks's avatar
hanhks
Frequent Visitor
8 years ago

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.