Skip to main content
Power BIPowerBI tutorials

How to display empty records in a Power BI report

In this section, we show you how to display empty records in a Power BI report with an example. While creating a Power BI report, Power Bi automatically hides empty records. For example, when you create a report for sales by state, you hide all the states whose sales are empty.

Show empty records in a Power BI report Example 1

In this example, we will use a table that we created in our previous post. I suggest you refer to the Create a table article to understand the same. If you look at the Power BI table, you don't have any product subcategories that don't have sales.

show-empty-records-in-a-power-bi-report-1-7384556

Click the down arrow next to the column (or field) to open the context menu.

show-empty-records-in-a-power-bi-report-2-6117315

please select Show items with no data context menu option.

show-empty-records-in-a-power-bi-report-3-3580466

Now you can see the subcategory of products with empty sales.

show-empty-records-in-a-power-bi-report-4-8919896

Let me scroll to the end of the table

show-empty-records-in-a-power-bi-report-5-3327668

Show empty records in a Power BI report Example 2

In this example, we will use a bar chart that we created earlier. I suggest you refer to the Create a Bar Chart article to understand the same.

show-empty-records-in-a-power-bi-report-6-9417149

Let me sort the chart by Sales Amount in ascending order. If you look at the graph, there is no state that does not have sales.

show-empty-records-in-a-power-bi-report-7-5803192

Click the down arrow next to the status column and select Show items with no data context menu option.

show-empty-records-in-a-power-bi-report-8-4190237

Now you can see the statuses with empty sales

show-empty-records-in-a-power-bi-report-9-8932331
Maybe you are interested >>>  Extending Power BI buttons beyond the default icons
error: Attention: Protected content.