Show Empty Records in a Power BI Report

In this section, we show you how to Show Empty Records in a Power BI Report with an example. While you create a Power BI report, it automatically hides the empty records. For example, when you create a report for state-wise sales, then it hides all the states whose sales are empty.

Show Empty Records in a Power BI Report Example 1

In this example, we are going to use a Table that we created in our earlier post. I suggest you refer to Create a Table article to understand the same.

If you look at the Power BI table, it doesn’t have any Product Subcategory that has no sales. Click the Down arrow beside the Column (or field) will open the context menu.

Show Empty Records in a Power BI Report 2

Please select Show items with no data option from the context menu.

Show Items with No Data Option 3

Now you can see the Product Subcategory with empty sales.

Show Empty Records in a Power BI Report 4

Let me scroll to the Table end.

Show Empty Records in a Power BI Report 5

Show Empty Records in a Power BI Report Example 2

In this example, we are going to use a Bar Chart that we created before. I suggest you refer to Create a Bar Chart article to understand the same. It has the State name on the Axis, SalesAmount as Values, and Order Quantity as the Color Saturation.

Let me sort the chart by Sales Amount in Ascending order. If you look at the chart, it doesn’t have any State that has no sales.

Show Empty Records in a Power BI Report 7

Click the Down arrow beside the State Column and select Show items with no data option from the context menu.

Show Items with No Data Option 8

Now you can see the States with Empty Sales

Show Empty Records in a Power BI Report 9