Blank value not colored in matrix

[IlijaPA]

Hello guys,

I am trying to do some custom coloring on matrix data and I am unable to figure out how to color the blank values in the respective rows only and not on the whole matrix.

Can you give me a hint on what I can try to achieve this?

This is my color measure which I use in conditional formating of the value:

and this is the matrix and rows which I was able to color but if a row contains a blank value in a column it will not be colored.

[themistoklis]

@IlijaPA 

Add another row and put the following formula

SELECTEDVALUE('GR Current incident number vs duration'[Assignee], "NA") = BLANK(), "#99e3dd"

+ this one if necessary

SELECTEDVALUE('GR Current incident number vs duration'[Assignee], "NA") = "", "#99e3dd"

[IlijaPA]

Hi,

Thank you but It doesn't work, I've tried that already. My idea is to have the entire row which is already colored in the same way not matter if it contains blanks. And the other rows which are white they need to stay white, associated blanks included.

[themistoklis]

@IlijaPA 

Can you not replace blanks with zeros by simply additing to the measure (used in conditional formatting) + 0 at the end.

It seems that PowerBI cannot add the same colour when cells are blank

[IlijaPA]

I even managed to get zero instead of blank and still it doesnt want to color the 0 values.