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.
Please select Show items with no data option from the context menu.
Now you can see the Product Subcategory with empty sales.
Let me scroll to the Table end
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.
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.
Click the Down arrow beside the State Column and select Show items with no data option from the context menu.
Now you can see the States with Empty Sales
