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, Power Bi 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.

Show Empty Records in a Power BI Report 1

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 Empty Records in a Power BI Report 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.

Show Empty Records in a Power BI Report 6

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 Empty Records in a Power BI Report 8

Now you can see the States with Empty Sales

Show Empty Records in a Power BI Report 9