cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kcopeland Frequent Visitor
Frequent Visitor

How do I get my data to NOT sum when creating visualizations?

Hi,

I'm creating my first visualization. My query shows enrollment numbers (students enrolled in a school) by month and year. When I go to create the visualization, the data automatically sums. I don't want it to sum, I want it to show the acutal enrollment numbers I have listed. How do I get it to NOT sum?

Thanks in advance!

8 REPLIES 8
khlebak Regular Visitor
Regular Visitor

Re: How do I get my data to NOT sum when creating visualizations?

Click on the field you need (enrollment numbers) on the far right, then go to the modeling tab and you'll see "default summarization". Select "don't summarize" from the drop down and you'll be all set!

Capture1.JPGCapture.JPG

 

kcopeland Frequent Visitor
Frequent Visitor

Re: How do I get my data to NOT sum when creating visualizations?

Thanks for the quick response! Now it gives me the “count” instead of the actual number. Thoughts?

khlebak Regular Visitor
Regular Visitor

Re: How do I get my data to NOT sum when creating visualizations?

Can you share an example of your visualization and data?

kcantor Super Contributor
Super Contributor

Re: How do I get my data to NOT sum when creating visualizations?

@kcopeland 

Have you verified the data type of the column of data you are using? 

Also, recheck the do not summarize because that same aggregate/non-aggregate area has a count and a distinct count. Double checking never hurts and we have all clicked a little too quickly and caught the wrong selection at one time or another. You can do this from the visual by clicking the drop down area by the field name and selecting do not summarize there for the actual visual.

summarize.JPG



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




kcopeland Frequent Visitor
Frequent Visitor

Re: How do I get my data to NOT sum when creating visualizations?

IMG_5579.jpgIMG_5580.jpgIMG_5581.jpg

kcopeland Frequent Visitor
Frequent Visitor

Re: How do I get my data to NOT sum when creating visualizations?

IMG_5582.jpg

kcopeland Frequent Visitor
Frequent Visitor

Re: How do I get my data to NOT sum when creating visualizations?

I changed the summarization to "don't summarize" so now its counting. I just want the raw data. How do I get that? Thanks for your help!

Community Support Team
Community Support Team

Re: How do I get my data to NOT sum when creating visualizations?

Hi @kcopeland ,

Actually, the value will be aggregated when you create most of the visualizations in power bi.

As I know, we only could show the raw data without sum with table visual currently in power bi.

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors