Removing Default SUM keyword in Power BI Visuals

[sakula4]

Dear Team,

When adding numeric fields to a visual, Power BI automatically applies a Sum function, displaying "Sum of [Field Name]." I would like to ensure that the field name appears without the default summarization, while still retaining the ability to apply summarization when needed.

To achieve this:

1. Change Aggregation Setting: Click on the numeric field in the visual, go to Summarization and select “Do Not Summarize.”

2. Use Data Category Formatting: If applicable, adjust the Data Type or format settings to maintain numeric integrity while preventing auto-summarization.

3. Modify Field Headers: Rename fields in the Fields pane to remove “Sum of” manually.

Could you please confirm if there is an alternative method to achieve this consistently?

Reference:-

Regards,

The Ask

[v-prasare]

Hi @sakula4,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

@Ritaf1983 & @Jai-Rathinavel  thanks for your prompt response

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[sakula4]

Not working 

[Jai-Rathinavel · Accepted solution]

@sakula4  You can turn off all default summarization across the model using the new TMDL view.

1. Head over to Options -> Global -> Preview Features -> TMDL View (enable it and restart the power bi desktop)

2. Now drag your model or tables into the TMDL view 

3. Using CTRL+F search for "summarizeBy: sum" and replace it with "summarizeBy: none" and Hit apply.

4. Default summarization of sum will nowhere appear in the model now.

Thanks,

Jai Rathinavel

[sakula4]

Hi @Jai-Rathinavel , I believe you undetstood my question...

[Jai-Rathinavel]

@sakula4 Hope it helped. 

[Ritaf1983]

Hi @sakula4 
You can also handle with this from column tools in table view.
In thia way yow won't need to change it multiple times in visuals:

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[sakula4]

This approach may result in a loss of granularity, which is not desirable. While summarization is necessary, the visual should display only the field name without explicitly showing the SUM type when added.