In Power BI Desktop, numeric fields are automatically set to "Sum" when added to visuals. While this is useful in many cases, it can be frustrating for users who frequently work with data that should not be aggregated.
Feature Request:
Please add a global or report-level setting that allows users to set the default summarization behavior for all fields—especially numeric ones—to "Don't Summarize".
Why This Matters:
- Saves time by reducing repetitive manual changes.
- Prevents accidental misinterpretation of data due to unintended aggregation.
- Improves usability for users working with detailed or non-aggregated datasets (e.g., IDs, reference numbers, or pre-aggregated values).
- Aligns with user expectations in scenarios where summarization is not appropriate.
Suggested Implementation:
- A toggle in Options > Report Settings or Data Load to choose the default summarization behavior.
- Alternatively, allow setting summarization preferences at the column level in the data model.
This small change would significantly improve the user experience for many Power BI users
dm-p
on:
Allow standard Focus Mode for custom visuals that ...
on:
More granular control and better design experience...
on:
Consistent TMDL serialisation across developer mac...
on:
Allow Users to Configure the Refresh Frequency of ...