Show items with no data in Power BI

In Power BI visual by default the items with no data are excluded in the visual. But we can enable “Show items with no data” in the visual, when we want to show all categories, even if there's no data.

Let’s we have the following data:

Here, the Country India, Brazil and Canada, does not have any value.

Let’s create a visual and demonstrate this by following steps:

Step 1: Let’s we have created a Line chart and add the Country and GDP column in the X-axis and Y-axis respectively.

We can see that the categories with blanks i.e. India, Brazil and Canada are not shown.

Step 2: To show the items with no data, select the visual (e.g., bar chart, table). In the Fields pane, right-click the categorical field (e.g., Country, Region) we added to the Axis or Rows.

Step 3: Click "Show items with no data".

Now we can see the countries with blank values. Now the challenge is that we want to show the blank as 0. To achieve this, we have to modify the value field that we are using.

Let’s create a DAX measure.

DAX GDP Measure = COALESCE(SUM(CountryGDP[GDP]), 0)

In place of the column field let’s use the GDP Measure. Now we can see the 0 values in place of blanks. Actually, COALESCE function returns the first non-blank value.