Add an option to force all table columns to the "Do Not Summarize" Default Summarization option

[AlexBarbeau]

When working and developing Power BI Desktop models, and by extension datasets on the service, there are many columns with numeric values that should not be aggregated. These include a year in a date table, a item number in a products table, and so on. Having to scroll through the entire model to set these as "Do Not Summarize" is tedious and unproductive, and accordingly having one place to change this setting would save time when starting a new model. This would also halt the use of implicit measures, enabling DAX measures as the only method of aggregation, which greatly enhances the data modeling options. This could go into the Options menu, and preferably is a Global setting, but could also work as a Current File setting.

[janice_gonzales]

Why can't the default be "Don't summarize" instead of "Summarize". That makes no sense to me.

[colgan_tom]

This. Or batch-update.

[alain_lepage]

It is very time consuming to reset the field in a table to don't summarized. I believe it will be better to set the default to don't summarized.

[a_verspeek]

Please!

[krnlchksh2]

Please add this feature. It is very annoying all the time going to the columns and selecting Don's summarize option. On top of that we would have to do it one column at a time.

[nir_roznak]

I need the same option but change the columns summarization to average, and also its display decimal place, at least enable selecting multiple columns and apply same display/summarization options on all

[binhcao]

The default should be DO NOT SUMMARIZE. Currency data types are already summarized with SUM. Dates do not get summarized. Foreign Key columns participating in relationships do not get summarized. That left us with business keys, flags, and other numeric but are not summarize-able columns. There usually are not too many columns in a table that need to be set to SUMMARIZE. So it makes sense to change this default to NOT SUMMARIZED. There, I voted #118. I think my vote weighted more 🙂

[pingsia]

Yes please! Very time consuming to change them to "Don't Summarize"!!!

[marcrmaurice]

PLEASE!!!

[diego_perez2]

It should backwards, "Don't Summarize" by default, it's pretty annoying to change this. Thanks!