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?
on:
Connection Timeout to Azure Analysis Services (AAS...
mattlee
on:
Problem : Data labels stacked bar chart