Forum Discussion

bjnodello's avatar
bjnodello
Helper II
9 years ago
Solved

Conditional Formatting with Blank Values

Hello All,   Does anyone have and tips/tricks for dealing with blank values and conditional formatting?  It appears to be treating the entry as "0" and I would like it to be ignored.     Thanks, ...
Need Help
  • bjnodello's avatar
    bjnodello
    9 years ago

    Thanks v-yulgu-msft and SwaroopRoyM,

     

    I may not have been clear what I was asking.  Here are the settings I have for a set of table values in Power BI Desktop:

     

    Note, in the screenshot below the blank value is shaded the same as the 0.  I would like the blank values to be ignored.  I am not aware of a way to use an IF statement to conditionally format in Power BI Desktop.  Is this really possible? If so can you provide additional details please?

     

     

    Thanks,

     

    Brett

SwaroopRoyM's avatar
SwaroopRoyM
Helper II
9 years ago
Hi, You can use IF condition to look for "blank" and do the necessary formatting. Thanks, Swaroop