How to Not Show Blank in Power BI Card

Nothing ruins the flow of a polished Power BI dashboard quite like a card visual prominently displaying a jarring "(Blank)." It looks unprofessional, confuses your audience, and can break the narrative you’re trying to build with your data. This isn’t an error, it's just how Power BI handles situations where there is no data to show. This article will walk you through four practical and easy methods to replace those blanks with something more meaningful, like a simple zero or a custom message.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

First, Why Does Power BI Show "(Blank)"?

Before jumping into the fixes, it helps to quickly understand the cause. Power BI displays "(Blank)" in a card when a measure or filter context results in no value. This happens for a few common reasons:

• No Data Exists: You might be filtering for a brand new product that hasn't sold yet, a sales rep who just started, or a marketing campaign in a region where it's not active. In these cases, there are no rows in your data table that match the filters, so measures like SUM or AVERAGE have nothing to calculate.
• Measure Logic Returns Blank: Some DAX (Data Analysis Expressions) functions can explicitly return a blank value. For example, dividing a number by zero or using functions like DIVIDE and SELECTEDVALUE can result in a blank if conditions aren’t met.

Seeing "(Blank)" isn't a bug. It’s Power BI’s way of accurately telling you "there is nothing here." Our goal is to override that default behavior to make our reports cleaner and easier to understand for the end-user.

Method 1: The Simple "+ 0" Trick (For Numeric Values)

This is often the quickest and easiest way to turn a blank into a zero for any measure that deals with numbers. It's a simple trick that works beautifully for common KPIs like total sales, units sold, site traffic, etc.

Let's say you have a basic measure to calculate total revenue:

Total Revenue = SUM(Sales[Revenue])

If you filter your report for a specific day when no sales were made, a card using this measure will show "(Blank)." To fix it, you simply add + 0 to the end of your DAX formula.

The updated measure looks like this:

Total Revenue = SUM(Sales[Revenue]) + 0

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Why Does This Work?

In DAX, a blank value is not the same as zero. But when you perform a mathematical operation, DAX needs to convert the blank to a number to complete the calculation. In this context, it converts the blank to 0. So, BLANK() + 0 results in 0.

When to Use It

• For Simple Aggregations: It's perfect for sum, count, and other aggregations where '0' is a logical and descriptive substitute for "no data." Total leads, support tickets, or items sold are great candidates.

When to Be Cautious

• With Averages: Be careful when using this trick on measures that calculate averages. An average sale price of '$0' could be misleading, implying something was sold for free, whereas "(Blank)" more accurately means no sales occurred. In these cases, one of the other methods below is a better choice.

Method 2: Using the COALESCE Function

The COALESCE function is a clean, modern DAX function designed specifically for this kind of problem. It evaluates a list of expressions in order and returns the first one that does not result in a blank.

The syntax is straightforward: COALESCE(expression1, expression2, ...).

To fix our Total Revenue measure, we would wrap our existing calculation inside COALESCE and provide 0 as the fallback value.

Total Revenue = COALESCE(SUM(Sales[Revenue]), 0)

This formula tells Power BI: "Try to calculate the SUM of Sales[Revenue]. If that result is blank, use 0 instead."

Advantages of COALESCE

• Readability: It's very clear what your formula is trying to accomplish. Someone reading your DAX code will immediately understand the intent.
• Versatility: Unlike the + 0 trick, COALESCE works for text values as well. For example, if you wanted to display a default message for a category:

Product Category = COALESCE(SELECTEDVALUE(Products[Category]), "No Category Selected")

For most scenarios, COALESCE is an excellent modern replacement for the + 0 trick because it's more explicit and versatile.

Method 3: The Powerful Combination of IF and ISBLANK

For ultimate control and flexibility, nothing beats a classic IF statement paired with the ISBLANK function. This combination lets you define exactly what should happen when your measure is blank, allowing you to return numbers, text, or even the result of another measure.

The standard structure looks like this:

Measure = IF(ISBLANK([Your Core Measure]), [Value to show if blank], [Your Core Measure])

Let’s apply this to our revenue example. We'll first create our core measure:

Core Revenue = SUM(Sales[Revenue])

Then, we create a new, "display" measure specifically for our card visual:

Display Revenue Card = IF(ISBLANK([Core Revenue]), "No Sales Data", [Core Revenue])

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Customizing the Fallback Value

With this method, you have complete freedom over what the user sees.

• Return Zero: IF(ISBLANK([Core Revenue]), 0, [Core Revenue])
• Return N/A Text: IF(ISBLANK([Core Revenue]), "N/A", [Core Revenue])
• Return a Blank String: Sometimes you might want an empty card instead of "(Blank)." You can use two double quotes: IF(ISBLANK([Core Revenue]), "", [Core Revenue])

A Critical Note on Data Types

Be very careful with data types when using IF. Measures in Power BI can only return a single, consistent data type (e.g., Decimal Number, Text, Whole Number). If one part of your IF statement returns a number (your core measure) and the other returns text (e.g., "N/A"), Power BI will automatically convert the entire result to a text type.

This is fine for a card visual, but it can cause problems if you use that same measure in a bar chart or line graph, which require a numeric axis. You’ll get an error, or the chart won’t display correctly.

The Solution: Use Format Functions

To avoid this, you can wrap your numeric result in the FORMAT function to convert it to text, ensuring both possible outcomes of the IF statement are the same data type. This is best practice for creating display-only measures:

Display Revenue Card = 
IF(
    ISBLANK([Core Revenue]), 
    "No Sales Today", 
    FORMAT([Core Revenue], "$#,##0")
)

Now, this measure will always return a text value, making it safe to use in a card and preventing it from being accidentally used in charts that require numbers.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Method 4: Dynamic Titles for Context

This final method is a clever workaround that doesn't change the data itself but instead provides context to the user by dynamically changing the title of the card visual. This is ideal when you actually want the underlying data to remain blank (to not skew totals or averages) but need to explain to a viewer why the card is empty.

Here's how to set it up:

Step 1: Create a Measure for the Title

Just like our other methods, you'll start by writing a DAX measure. This measure will check if your main measure is blank and return a different text string accordingly.

Revenue Card Title = IF( ISBLANK(SUM(Sales[Revenue])), "Total Revenue (No Data Available)", "Total Revenue" )

Step 2: Assign the Measure to the Card's Title

1. Select the card visual on your report canvas.
2. Go to the Format visual pane (the paintbrush icon).
3. Expand the Title section and turn it on if it's not already.
4. Beside the Text input box, you'll see a small fx button. This is for Conditional Formatting. Click it.
5. In the new window, set the Format style to Field value.
6. In the What field should we base this on? dropdown, select your new title measure (Revenue Card Title).
7. Click OK.

Now, your card will still show "(Blank)" in the main data area, but the title will automatically change based on the data. When there is revenue, the title is "Total Revenue." When there isn't, it changes to "Total Revenue (No Data Available)," giving your user instant, clear context.

Choosing the Right Method for Your Needs

So, which approach should you use? Here’s a quick guide to help you decide:

• Use + 0 for... the absolute fastest fix for simple numeric KPIs (like totals or counts) where zero is a perfectly acceptable representation of no data.
• Use COALESCE for... a cleaner, more readable, and modern way to handle both numeric and text fallbacks. This should be your default choice in many cases.
• Use IF(ISBLANK()) for... maximum control. Use it when you need custom text messages or need to implement more complex logic. Just remember to manage your data types carefully.
• Use Dynamic Titles for... providing context without changing the underlying blank value. This preserves the integrity of other calculations while improving the user experience.

Final Thoughts

Dealing with blank values in Power BI cards is a fundamental part of creating professional, user-friendly reports. Armed with these four methods - the quick + 0 trick, the clean COALESCE function, the flexible IF/ISBLANK combo, and clever dynamic titles - you now have a full toolkit to handle any scenario and make sure your dashboards always look polished and communicate clearly.

Building intuitive reports shouldn't mean constantly battling formatting quirks or memorizing DAX functions. At Graphed, we think you should focus on insights, not on housekeeping. Instead of writing formulas to handle blank values, you can use simple, natural language to ask questions, and Graphed automatically generates clean, real-time dashboards for you. We handle all the data nuances in the background, so you can go straight from question to answer without worrying about a rogue "(Blank)" again.