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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi bjnodello,

 

In your scenario, what data source did you use to import to PowerBI desktop? In my test, I didn't get "0" value when I import blank values. Would you please provide some sample data so that we can reproduce your issue and give you more advice? 

 

Thanks,
Yuliana Gu