Table of Contents
Removing blank rows in Power BI is a simple process that involves filtering the data to exclude any rows with blank values. This can be done by selecting the column that contains blank values and setting a filter to exclude those rows. For example, if the data set contains a column for customer names and some rows have blank values, the filter can be set to only include rows where the customer name is not blank. This will remove all the blank rows from the data set, making it easier to analyze and visualize the data accurately.
The easiest way to remove blank rows from a table in Power BI is to use the Remove Blank Rows feature within the Power Query Editor.
The following example shows how to use this feature in practice.
Example: How to Remove Blank Rows in Power BI
Suppose we have the following table in Power BI that contains information about various basketball players:
Notice that there are several rows that contain blank values in every column.
Suppose that we would like to remove these rows from the table.
To do so, click the Home tab along the top ribbon, then click the Transform data icon:
This will bring up the Power Query Editor:
To remove the blank rows, click the Remove Rows icon, then click Remove Blank Rows:
This will automatically remove all of the blank rows in the table:
When you exit out of the Power Query Editor, it will ask if you’d like to apply the changes you made to the original table.
Click Yes to apply the changes.
Additional Resources
The following tutorials explain how to perform other common tasks in Power BI: