Forum Discussion
Matrix: Conditional formatting on blank cells
Hi All, Is there any way to apply conditional formatting in Matrix cells where there are no values for intersection? Currently based on rules, it just applies colors for non zero values. ...
in your matrix measure values, create a "if" condition for a blank values and with values <> blank, create a varaibles with colors anda aply to condicional filed.
measure =
var blankvalues = "black"
var nonblankvalues = "green"
if(
tableWithValues <> Blank,
nonblankvalues,
blankvalues,
)
you can use this for more option in your condition, like, tableWithvalue >= 2, "red" etc...