Forum Discussion

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
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

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