How to Add or Remove Blank Rows from a Power BI Matrix

Manually adding and removing rows from a Power BI Matrix takes a couple of different techniques. Removing rows can be as simple as applying a filter at the visual level when there are specific rows or logic that can be applied. Adding blank rows is a multi-step process that requires the use of several techniques.

To add blank rows to a Matrix Visual in Power BI, create a new empty measure. Rename the measure with a space to give the look that it is blank. Blank Rows can be removed by filtering at the visual or page level. Blank rows can also be removed by filtering a data model in Power Query.

Removing Blank Rows from a Power BI Matrix

To remove blank rows from a matrix visual in Power BI, select the visual. Expand the Filters panel on the right side of the screen. Expand the filter related to the field that is showing a blank row. Use basic filtering to select all except for the blank value.

An example of a matrix with a blank row

Blank or null values can be filtered out of a Power BI visual

After the filter is applied, the blank will no longer show up on the visual.

De-select a blank from basic filtering on a visual, page, or entire report to remove them.

Power BI provides a number of filtering settings. You can filter out a value for an individual visual, or you can drag and drop the field to the bottom of the Filters panel.

There is a section for Filters on this page, which applies a filter to all visuals on a page. Filters on all pages will hide a blank row from all visuals in the enter report across all tabs.

How to add Blank Rows to a Matrix in Power BI

To add a blank row in a matrix visual, create an empty measure to add as a row. Then rename the new empty measure to a space. By renaming the field it will appear as if the row were blank within the Matrix visual. It will look like the following before being renamed:

Use a blank measure in Power BI renamed with a space to create a blank row or column.

To rename a field, double click on the name. Then type over the existing text. This will not change the name of the field in other visuals but will rename the field for the specific visual it’s been assigned to.

When you want to add a blank row directly into a dataset, you would need to append the data within Power Query with a blank and use an index column to set a specific sort order after adding the data to a Power BI table or matrix.

Creating a Blank Empty Measure in Power BI

To create a blank measure in Power BI, click on New Measure from the Power BI ribbon. Use the syntax Blank = “” where Blank becomes the name of the measure, and two quotes signify text with no characters to be displayed.

Within Power BI, this setup would look like the following:

Click New measure and create one that equals two quotes to create a blank

The third problem that we need to solve is that our columns have to be measures for us to be able to insert a blank measure in between them.

Switching Values to Rows in Power BI

Values added to a Power BI Matrix will show each value as its own column. However, we want to insert a blank row into the Matrix. To do so, we need columns to display as rows. We can adjust this setting under Format Your Visual >Values > Options.

By default, Power BI matrix will show values as individual columns.

This option places all of the measures or fields into the rows of your matrix visual. This makes it much easier to work with because you can drag measure names to change the order in which rows appear in the visual.

Switch values to rows to make it easy to drag and drop measures and columns into specific order

Assign a Blank Measure to a Matrix Visual

After creating a Blank Measure and adjusting the Matrix visual to show values on rows, we can drag and drop the new Blank Measure to our set of assigned fields. After it’s assigned, double click on the name of the Blank Measure and replace it with a Space character to give the look that the row name is empty or blank.

A blank row can be inserted into a matrix visual as a row consisting of an empty measure.

The blank row will appear in our Matrix visual like a row has been skipped. Other values can be manually adjusted in order by dragging and dropping them within the values field of Power BI.

Conclusion

To add a blank row or column in Power BI, create an empty measure. Click on New Measure and use the DAX formula: blank = “”. Quotes normally surround text, but when put together it creates a blank.

Try switching a matrix to show values on rows to make it easier to drag and drop them to place them in order.

Blanks can be filtered out at the dataset level using Power Query, or you can update the filters for an individual matrix visual, a page, or for the entire report. Power Query is a recommended method to avoid future calculation errors and other issues that can arise when trying to aggregate numbers with nulls present.

Scroll to Top