Power BI: How to Remove (Blank) from Card Visualization


If you have a table with blank values in Power BI and you add a card visualization to a report, it’s possible that a (Blank) value will appear in the card, such as the following card:

The easiest way to hide this (Blank) value is to use the Conditional formatting feature within the Visualizations tab to make the font color of the text match the background color of the card.

The following example shows how to do so.

Example: How to Remove Blank from Card Visualization in Power BI

Suppose we have the following card in a report in Power BI that shows the total count of rebounds for basketball players on various teams:

It turns out that there are only blank values for the Rebounds field, which explains why the card displays a value of (Blank) instead of a numeric value.

To hide this (Blank) value in the card, you must first click the card to make it active.

Then click the Format your visual tab under Visualizations.

Then click the dropdown arrow next to Callout value.

Then click the Conditional formatting icon next to Color:

Power BI remove blank from card

In the new window that appears, click the If value dropdown arrow and choose is blank.

Then click the dropdown arrow next to then and choose the color that matches the background color of the card:

Once you click OK, the font color of the (Blank) text in the card will become white.

Since this matches the background color of the card, the (Blank) will essentially be hidden:

Note that in this example we chose to make the font color white because the background color of the card was white.

If you card has a different background color then you will need to choose the font color that matches the background color in order for the (Blank) to be hidden in the card.

Additional Resources

The following tutorials explain how to perform other common tasks in Power BI:

Power BI: How to Remove Column Headers in Table
Power BI: How to Remove Duplicates
Power BI: How to Remove Date Hierarchy

Leave a Reply

Your email address will not be published. Required fields are marked *