Forum Discussion

PBI_Rookie's avatar
PBI_Rookie
Helper I
5 years ago
Solved

Matrix conditional formatting- Blank values

Hello All,   I have been using the below to format values in a matrix. It works well except for null values I have in my table. I've tried a few things without success. Am I a firstnonblank  somewh...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi PBI_Rookie ,

    Sorry for replying late. Did the blank value not show in the matrix? If so, you need to create a seprate table for this column, create relationships between them and create a measure to + 0 to show:

    Table = DISTINCT('Specifications'[V])
    Measure = SUM('Table'[V]) + 0

    Now the conditonal format rule should work:

    Attached a sample file in the below, hopes to help you.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
5 years ago

PBI_Rookie , Also add condition for blank

IF(LowerLimitCheck >0, "#f25a38",

Switch( True() ,

isblank(UpperLimitCheck) , "#04bf9d"

UpperLimitCheck >0, "#f25a38", "#04bf9d"))