Forum Discussion
Conditional Formatting on Blank Matrix Cells
Hello, please help me out I am new to DAX! So, I am trying to apply conditional formatting to this sample table such that the blank cells are treated as zero, and also to remove the formatting ...
Anonymous , ok got, if the value is blank, conditional formatting will not work
change you measure with +0 (which you have used on values and then add condition for that [measure]=0 in the color
Asumme you are displaying SUM(Append1[PDQ])
use measure 1 =SUM(Append1[PDQ])+0
SWITCH (
TRUE (),
[measure 1 ]=0 "red",
SUM(Append1[PDQ] )< CALCULATE (SUM(Append1[PDQ] ),DATEADD(Append1[MinDate],-7,DAY)), "pink",
SUM(Append1[PDQ] )> CALCULATE (SUM(Append1[PDQ] ),DATEADD(Append1[MinDate],-7,DAY)),"lightgreen")
Its still not working unfortunately. for example I need this column to be highlighted red. So the first blank after a value:
Also is there anyway to remove the conditional formatting from the first week?