Formatiting matrix

Further to this Anonymous 

I do have a potential work-around.

First, structure the data by unpivoting it in Power Pivot and adding a column that is "1" for KO and "0" for OK:

This will then make it much easier to create a Matrix using those values!

Then, create a measure that summarises "hasKO" by making a sum of the values. We now know that if the sum = 0 there are no KO's and anything else means that there is at least one.

anyKO = sum(Sheet1[hasKO]) 

 

Use this measure in the conditional formatting to colour values with 0 as green and anything else as red:

This will also colour the value totals. Using the value totals as a comparison will give you an indication of the machine and server situations:

 

 

 

 HTH

 

Pi