cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Default summarization feature missing

Hi guys!

So i got really fed up with clicking on every single value to set it to "SUM" when creating my table. I found out there should be a "default summarization" option in the MODELING card. Yet there is none (and also some of other features are missing). Why is this?

Thanks for answers 🙂 

 

Fringeart_0-1596180752881.png

 

1 ACCEPTED SOLUTION

@Anonymous 

you can go to the Model view, Ctrl+ click on all demanded fields and change its default summarization

Снимок.PNG


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

7 REPLIES 7
Pragati11
Super User
Super User

Hi @Anonymous ,

 

It's not missing, it's just moved to a new area.

I see that you are using the new ribbon in Power BI.

 

Click on your column in FIELDS pane, you will see something like this in the ribbon:

Pragati11_0-1596181256400.png

 

From here you can modify default summarisation.

 

Thanks,

Pragati

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Anonymous
Not applicable

Oh okay! So I do have to define the default summarization for each value and then it will work on?... Well that doesnt really solve my situation.  As i have lets say 40 values, that I will use only once. I would love to mark them all (e.g. shift+click) and then change the summarization.

@Anonymous 

you can go to the Model view, Ctrl+ click on all demanded fields and change its default summarization

Снимок.PNG


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Anonymous
Not applicable

Yesss!

Thank you very much 🙂 This community is indeed very helpful. Have a good day guys! 🙂

Hi @az38 ,

 

Thanks for this solution. I missed that ADVANCED part in Modelling tab. 🙂

 

Thanks,

Pragati

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Hi @Anonymous ,

 

Yes.

 

Thanks,

Pragati

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

az38
Super User
Super User

@Anonymous 

default summarization option is available on Field level. Pick your field in the right pane and go to Column tools or Measure tools ribbon


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors