Forum Discussion
Blank value not colored in matrix
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.
4 Replies
- themistoklis
Community Champion
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"
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
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
