Easy Tech TutsHow to Use Don't Summarize in Tables in Power BI (Show Raw Values) Easily 2026
By Impran M N
Power BI aggregates numeric fields by default, which is helpful for totals but can hide the exact raw values you sometimes need in a table. This guide shows how to use the Don't Summarize setting to display data exactly as it appears in your source, without automatic summing or averaging. It's a small setting that can prevent confusion in detailed reports.
01Find the Don't Summarize setting
Locate the field's aggregation options in your table or matrix visual, where Power BI lets you choose how a numeric column is calculated.
02Switch the field to Don't Summarize
Change the aggregation setting from sum, average, or another calculation to Don't Summarize so the raw value is shown as-is.
03Check the table's display
Review the table to confirm it's now showing individual raw values instead of an aggregated total.
04Understand when raw values matter most
Use this setting in situations where precise, unaggregated figures are important, such as auditing records or reviewing individual transactions.
05Follow best practices for accurate reporting
Apply Don't Summarize selectively, since showing raw values everywhere can make large tables harder to read than a properly aggregated view.
Frequently asked questions
Why does Power BI automatically summarize my numbers?
By default, Power BI treats numeric fields as measures that need aggregation, such as sum or average, unless you tell it otherwise.
Does Don't Summarize work on any numeric field?
Yes, it's an aggregation option available for numeric columns in table and matrix visuals.
Will using Don't Summarize slow down my report?
Not typically, since it changes how a value is displayed rather than adding significant processing overhead.
Can I switch a field back to summarized after using Don't Summarize?
Yes, the aggregation setting can be changed back to sum, average, or another option at any time.
When should I avoid using Don't Summarize?
Avoid it in large tables where showing every raw value would overwhelm viewers who need a summarized overview instead.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
