Power BI
Needs VotesAdd an option to force all table columns to the "Do Not Summarize" Default Summarization option
Alex Barbeau on 19 Nov 2016 06:05:15
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.
- Comments (17)
RE: Add an option to force all table columns to the "Do Not Summarize" Default Summarization option
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 :)
RE: Add an option to force all table columns to the "Do Not Summarize" Default Summarization option
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
RE: Add an option to force all table columns to the "Do Not Summarize" Default Summarization option
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.
RE: Add an option to force all table columns to the "Do Not Summarize" Default Summarization option
Please!
RE: Add an option to force all table columns to the "Do Not Summarize" Default Summarization option
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.
RE: Add an option to force all table columns to the "Do Not Summarize" Default Summarization option
This. Or batch-update.
RE: Add an option to force all table columns to the "Do Not Summarize" Default Summarization option
Why can't the default be "Don't summarize" instead of "Summarize". That makes no sense to me.
RE: Add an option to force all table columns to the "Do Not Summarize" Default Summarization option
Or at least give me a multi select so I don't need to turn them off one at a time.
RE: Add an option to force all table columns to the "Do Not Summarize" Default Summarization option
Yes, please!
RE: Add an option to force all table columns to the "Do Not Summarize" Default Summarization option
Agreed, please prove an option to disable by default.