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

bjnodello's avatar
bjnodello
Helper II
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

Hello Brett,

 

If you don't want to see the "blank" value in the visual, you can do that by having this column as visual level filter. Once you have this column as visual level filter, go to "advanced filtering" option and choose "is not blank" option.

 

Hope this answers your query.

 

Thanks,

Swaroop