Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Rename Blank in Power BI

Cody Schneider••7 min read

Nothing's more frustrating than building a beautiful Power BI visual only to see a jarring "(Blank)" value sitting in your table or chart. It looks unprofessional, confuses stakeholders, and can even throw off your analysis. Fortunately, getting rid of these blanks is a common task, and there are several effective ways to replace them with something more meaningful, like "N/A," "Uncategorized," or a simple "0."

GraphedGraphed

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.

Watch Graphed demo video

This tutorial will walk you through the best methods for renaming blank values in Power BI. We'll cover solutions for both calculated measures (using DAX) and for raw text or category columns (using Power Query), so you can handle any blank value that comes your way.

Why Do Blanks Appear in the First Place?

Before we fix the problem, it helps to quickly understand why Power BI shows blanks. Blanks aren't errors, they represent a lack of data. This typically happens for a few common reasons:

  • Missing Data at the Source: The most common cause is simply having null or empty cells in your source file (like an Excel sheet or a SQL database table).
  • Relationship Issues: If you have two tables in your data model connected by a relationship (e.g., Sales and Products), and a row in one table doesn't have a matching key in the other, Power BI will return blanks for the values that can't be found.
  • DAX Calculations: Measures that perform calculations like division by zero or that try to sum up values where none exist will often result in a blank instead of an error.

Replacing these blanks makes your reports cleaner, easier for end-users to understand, and prevents misinterpretation of the data. Let's get into the solutions.

Method 1: Using DAX to Replace Blanks in Measures

When you're dealing with blanks that appear in the results of a calculation or measure, DAX (Data Analysis Expressions) is your best tool. Measures are a common source of blanks. For instance, if you're summing product revenue for a given day and no products were sold, the sum will be blank, not zero.

Here are a couple of practical DAX patterns to handle this.

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.

The Quickest Fix: Replace Blanks with Zero

If you want to replace a blank with a zero in a numerical measure, the easiest way is to literally add zero to your expression. Power BI will perform an implicit conversion that turns the blank into a 0 before adding your 0, neatly fixing the problem.

Let’s say you have a basic sales measure like this:

Original Sales = SUM(Sales[Revenue])

If you have products in a table that had no sales in a given period, this measure will show (Blank) for them. To fix this, simply add + 0 to the end.

Step-by-step:

  1. In Power BI Desktop, click on your measure in the "Data" pane on the right-hand side.
  2. The formula bar will appear at the top. Modify your DAX formula by adding + 0.

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

Now, any product or category that previously showed (Blank) will show 0 instead. This is a simple, highly effective technique for any measure that should display zero instead of nothing.

Replacing Blanks with Custom Text (e.g., "N/A")

What if you want to replace the blank with text, like "Not Applicable" or "N/A"? The + 0 trick won't work here. Instead, you need to use an IF statement combined with the ISBLANK() function to check for the blank value and provide an alternative text.

Let's use the same sales measure as an example. We want to show "N/A" wherever sales are blank.

Step-by-step:

  1. Create a new measure. We don't want to edit the original numerical measure, because this new version will output text, which can't be used for further mathematical calculations.
  2. Use the following DAX pattern:
Sales Display = 
IF(
    ISBLANK( SUM(Sales[Revenue]) ),
    "N/A",
    SUM(Sales[Revenue])
)

There's one important detail here. Power BI columns in a table or matrix visual have to have a single data type. They can't contain both numbers (your sales figures) and text ("N/A"). To solve this, you need to format the numerical result as text using the FORMAT function.

Here is the final, production-ready formula:

Sales Display = 
IF(
    ISBLANK( SUM(Sales[Revenue]) ),
    "N/A",
    FORMAT( SUM(Sales[Revenue]), "$#,##0" )
)

This revised measure checks if the sum of revenue is blank. If it is, it returns the text "N/A". If it's not blank, it takes the sales number and formats it as currency text (e.g., "$15,250"). Now both possible outputs are text, and your Power BI visual will display it perfectly.

GraphedGraphed

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.

Watch Graphed demo video

Method 2: Replacing Blanks in Columns Using Power Query

Sometimes, the blanks you need to fix aren't in a measure but in a descriptive or categorical column itself. For instance, you might have a "Region" column where some entries are simply empty, or a "Product Category" column that has null values.

The best place to fix these is in the Power Query Editor before the data even loads into your report. This cleans the data at the source, ensuring consistency across your entire report.

Step-by-step:

  1. From the "Home" ribbon in Power BI Desktop, click on "Transform data" to open the Power Query Editor.
  2. In the Power Query window, select the query (table) that contains the column you want to fix from the left-hand pane.
  3. Find the column with the blank values. Click on the column header to select it.
  4. Go to the "Transform" tab in the ribbon at the top.
  5. Click the "Replace Values" button.
  6. In the "Replace Values" dialog box, you need to tell Power Query what to find and what to replace it with.
  7. Click "OK".

Important Tip: Sometimes, a "blank" can be an empty text string ("") instead of a null value. If after replacing null you still see some blanks, simply repeat the "Replace Values" process, but this time leave the "Value To Find" box empty to find and replace the empty strings.

Once you are done, click "Close & Apply" on the "Home" ribbon to save your changes and load the clean data into your report. Now your visuals, slicers, and filters will show "Unassigned" instead of "(Blank)".

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.

Method 3: Creating a Conditional Column in Power Query

What if you don't want to change the original column, but would rather create a new, clean version of it for use in your visuals? A Conditional Column in Power Query is perfect for this.

Let's imagine you have a Sales Rep column, and some sales are not assigned to any specific rep, so the field is blank. Instead of altering the original column, you can create a Sales Rep (Clean) column.

Step-by-step:

  1. Open the Power Query Editor by clicking "Transform data".
  2. Select the query containing the column you want to work with.
  3. Go to the "Add Column" ribbon at the top and click on "Conditional Column".
  4. The Conditional Column dialog box is like an IF-statement builder. Set it up as follows:
  5. Essentially, this logic says: "If the Sales Rep column is blank, give me 'Unassigned'. Otherwise, just give me the original value from the Sales Rep column."
  6. Click "OK". A new, clean column will appear at the end of your table.
  7. Click "Close & Apply" back in the main ribbon. Now you can use this new Sales Rep (Clean) column in your visuals without worrying about any blanks appearing.

Final Thoughts

Cleaning up blank values is a fundamental skill that takes your Power BI reports from functional to professional. By using the right tool for the job — DAX for handling measures and calculated results, and Power Query for cleaning raw data columns at the source — you can ensure your dashboards are always clear, accurate, and easy for your audience to understand.

While mastering Power BI's tools is incredibly powerful for custom analysis, we know that the process of connecting data, cleaning it, and building reports can often be tedious and time-consuming. At Graphed we created a solution where you can skip the manual steps entirely. By connecting your sources and simply asking questions in plain English — like "create a chart of total monthly sales, but label any transactions with no assigned sales rep as 'Internal'" — you get real-time dashboards and answers in seconds, freeing you up to focus on strategy instead of report-building.

Related Articles