When you create a visual, Power BI only shows relevant data to properly manage how data is presented and displayed.
There may be times when you want to show items with no data. The Show items with no data feature lets you include data rows and columns that don't contain measure data.
To enable the Show items with no data feature, follow these steps:
Select a visualization panel.
In the Values fields well, right-click the field or click on the down arrow and select Show items with no data from the menu that appears, as shown in the following image:
The Show items with no data feature doesn't have any effect in the following circumstances:
There's no measure added to the visual, and the grouping columns come from the same table.
Groups are unrelated. Power BI doesn't run queries for visuals that have unrelated groups.
The measure is unrelated to any of the groups. In this case, the measure will never be blank for only some group combinations.
There's a user-defined measure filter that excludes blank measures. For example: SalesAmount > 0
Comments and Suggestions
0 comments
Article is closed for comments.