Forum Discussion

helenbjones's avatar
helenbjones
Frequent Visitor
7 years ago
Solved

Show Cells with conditional formatting but null value

Hi, need some help please. I have a matrix with values in and conditional formatting based on another value. I need null values to also show if the conditional formatting value is valid. So, for example, the sum value is 0 but the conditional formatting is based on a differenct column which has a value of 1 and so should give a geen cell. However, I am not getting this empty green cell and I need to.

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi helenbjones 

    You may try to create a measure with ISBLANK function.[SumValue] is 0.For example:

    Measure =
IF (
    ISBLANK ( SUM ( Table1[Column1] ) )
        || SUM ( Table1[Column1] ) > [SumValue],
    1
)

    Regards,

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi helenbjones 

    You may try to create a measure with ISBLANK function.[SumValue] is 0.For example:

    Measure =
IF (
    ISBLANK ( SUM ( Table1[Column1] ) )
        || SUM ( Table1[Column1] ) > [SumValue],
    1
)

    Regards,