How to switch Default Summation off in Power BI

[Roisin]

Hi all,

To be clear, this relates to Power BI online, not the Desktop version. Does anybody know how to switch Default Summation off in Power BI? Halfway through my graphing it begain including 'sum of' before every title, no idea how to turn it off!!!

Help please 🙂

[v-jingzhang · Accepted solution]

Hi @Roisin 

Most visuals require the value fields to be aggregated. For numeric fields, it usually takes Sum by default and adds "Sum of" to the name. You can rename it easily by right clicking on the field and select Rename for this visual. 

For the visuals that support unaggregated fields (Table, Multi-row Card), you can select "Don't summarize" option to show unaggregated values and it will remove "Sum of" from the name. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[JessicaE]

If you still want the column to sum, but don't want each visual to begin with "Sum of...", you can adjust this in settings here:

File - Options and Settings - Options - Current File - Report Settings

Scroll down to "Default Summarizations", and make sure the box is unchecked

[Syndicate_Admin]

I don't have that option for do not summarize. What am I missing?

[Syndicate_Admin]

This functionality is very different in the Desktop and is not apparent to me, the Desktop user.

[v-jingzhang · Accepted solution]

Hi @Roisin 

Most visuals require the value fields to be aggregated. For numeric fields, it usually takes Sum by default and adds "Sum of" to the name. You can rename it easily by right clicking on the field and select Rename for this visual. 

For the visuals that support unaggregated fields (Table, Multi-row Card), you can select "Don't summarize" option to show unaggregated values and it will remove "Sum of" from the name. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Edit]

Hi,

I got to this point, but it's just renaming the axis and still summing up the values under it. I'm using desktop Power BI. How can I show each values separately or get rid of the sum option?

Thank

[racchh]

hi how can i stop summing my column

[Roisin · Accepted solution]

Thank-you so much! this did the trick to rename it, as the option of 'dont summarize' is not in any dropdown.

[MarkLaf]

As you've seen, when you drag a column into a visual, the default behavior is to convert the field into an aggregation instead of the distinct list of values, e.g. "Sum of Value" instead of "Value".

This is an easy fix even when editing in the service which has a lot less functionality than BPI Desktop. Just click the drop-down on the field, and choose the "Don't summarize" option.

I'll add for completeness that if you do end up editing in PBI Desktop ever, you can actually change this default behavior of the field such that when you drag it into a visual it will behave differently:

[wdx223_Daniel]

try to use a real measure in the visual instead of quick measures.