Formatiting matrix

[Anonymous]

Hello,

I have table of data as below :

Center

Machine

install

checked

Filter

AccountLock

AccountUnlock

passwordcontrol

passwordReuse

authorized

Service

Log

timeout

apttsv1

sxmus1

OK

OK

OK

OK

OK

KO

OK

OK

OK

OK

OK

apttsv1

sxmus2

OK

OK

OK

OK

OK

KO

OK

OK

OK

KO

OK

apttsv1

sxmus3

OK

OK

OK

OK

OK

KO

OK

OK

OK

KO

OK

apttsv1

sxmus4

OK

OK

OK

OK

OK

KO

OK

OK

OK

KO

OK

apttsv1

sxmus5

OK

OK

OK

OK

OK

KO

OK

OK

OK

KO

OK

apttsv1

sxmus6

OK

OK

OK

OK

OK

KO

OK

OK

OK

KO

OK

apttsv1

sxmus7

OK

OK

OK

OK

OK

KO

OK

OK

OK

KO

OK

apttsv1

sxmus8

OK

OK

OK

OK

OK

KO

OK

OK

OK

KO

OK

apttsv2

sxmus9

OK

OK

OK

OK

OK

KO

OK

OK

OK

KO

OK

apttsv2

sxmus10

OK

OK

OK

OK

OK

KO

OK

OK

OK

KO

OK

apttsv2

sxmus11

OK

OK

OK

OK

OK

KO

OK

OK

OK

KO

OK

I would like to formatting the matrix below : 

I am trying to format the cell:

- OK : Green

- KO : Red

- Machine  : Green if all OK

- Machine : Red if there is a KO

-Center : Green if all Machine Green (All OK)

- Center: Red if any Machine Red (If any KO)

Could you please advise ? 

Thank you in advance.

Tg

[pi_eye · Accepted solution]

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

[Anonymous]

Thank you for your suggestion. 

[pi_eye]

Hi Tg!

Formatting Cell values is simple, you can format them conditionally using a column value. Here I have created a column that corresponds to "Log" and returns a colour:

First Log Color = If(Sheet1[Log]="KO","Red","Green")

Apply this to the formatting of the Log column by clicking the drop down next to the value name, and navigating to "background color" under "conditional formatting". 

In the resulting dialogue, choose Field Value as the format Style and select the new [First Log Color] field that has been created:

    

When applied, this will now color your "Log" field appropriately

To apply this to the whole visual you will need to create one for each column in the Matrix 

For the Centre and Machine values, I haven't been able to find a way to colour these conditionally, yet. There is currently an idea being upvoted if you would like to partake:

https://ideas.powerbi.com/ideas/idea/?ideaid=28bbb6fd-11d5-4713-aa23-030ad77d5d4f

Regards,

Pi