Table Visual Excludes Rows When Summarised Numeric Columns Contain Nulls

[De-Ahme]

I’ve encountered what appears to be a significant issue in Power BI relating to how the Table visual handles rows when certain numeric fields are set to summarise (e.g., Sum).

If a table visual displays fields all coming from the same table, and one or more of those fields are summarised numeric columns—for example:

Cost (summarised as Sum)

—then any row where these columns contain null/blank values is completely excluded from the table visual, even when:

• No filters are applied
• All filters are cleared/reset
• The record has valid values in all other displayed columns

Power BI effectively omits these rows entirely, giving the impression that they do not exist in the data model.

I originally assumed this was a modelling or filtering issue, but it turned out to be caused solely by the column setting. Changing the fields from Summarize → Don’t Summarize causes the missing records to reappear.

Rows should appear regardless of whether a summarised numeric column has a value, especially since the visual is row-based and all columns originate from the same table. Or, at least have a toggle setting to manage this behaviour.

Could Microsoft please confirm whether this is expected behaviour, a modelling constraint, or a potential defect in the Table visual’s handling of summarised numeric fields?