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

Thank you SwaroopRoyM and Sean.  This is one of many measures in the table so unfortunately, hiding blanks won't work as the other measures will not be blank.

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

    Hi bjnodello,

     

    As you mentioned in the original post, currently the conditional formatting cannot distinguish blank value separately. So, unfortunately your requirement cannot be achieved now. You can submit a wish to Microsoft at this page: https://ideas.powerbi.com/forums/265200-power-bi-ideas

     

    Thanks,
    Yuliana Gu