Forum Discussion
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 posible in Power BI.
Maxtrix compare 2 results
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
4 Replies
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.
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
I tested by your guide and it's OK. Very nice. Thank you.
