cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Change default data aggregation

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IX
Super User IX

Re: Change default data aggregation

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
Highlighted
Super User IX
Super User IX

Re: Change default data aggregation

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Highlighted
Regular Visitor

Re: Change default data aggregation

Thanks!

 

You saved me a ton of frustration.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors