Change default data aggregation

[Dave6547]

Hello,

I am creating a model which has thousands of columns.  I need the default aggregation to be 'maximum' for each one and not 'sum'.

I havent been able to find any way to do this short of selecting each one individually and changing it...

Is there a way to globally change this setting in powerBI and have it apply to everything?

[amitchandak · Accepted solution]

@Dave6547 , in the Model tab, you can select more than one column by pressing control and you will see the property tab. in the select the summarization.

https://www.youtube.com/watch?v=2SGXnYFdqu4 , Check after 2 Min

[Dave6547]

Thanks!

You saved me a ton of frustration.