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

YukiK's avatar
YukiK
Impactful Individual
5 years ago

You can definitely work this out by assigning values to blank values like others are suggesting, but you can also set a specific color as default formatting for conditional formattings, which worked my for case where I wanted blank as the same color as zero.