Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Dbstedman
New Member

Data not Summarizing

‎04-04-2022 07:32 AM

I'm looking for a way to sum the values into just East and West so I don't have four lines for each. I'm new to Power BI so it could just be an issue with how I imported my data. Is there something easy in the settings I missed or do I need to adjust my data import? Thank you

 

E-W Summary.png

Labels:
Message 1 of 5
1,799 Views
0
1 ACCEPTED SOLUTION
Pragati11
Super User
Super User

‎04-04-2022 07:36 AM

Hi @Dbstedman ,

 

Whenever you move certain columns to Power BI table visual, if they are of numeric type they should summarise themselves by default to SUM.

What are the data-types of all the columns in your screenshot above?

 

Best Regards,

Pragati Jain


MVP logo


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!!

View solution in original post

Message 2 of 5
1,795 Views
4 REPLIES 4
ribisht17
Super User
Super User

‎04-04-2022 07:59 AM

Check this one, 

ribisht17_1-1649084415346.png

 

 

Regards,

Ritesh

 

Message 5 of 5
1,753 Views
0
Dbstedman
New Member

‎04-04-2022 07:54 AM

I found my mistake. The number coloumns were set to "Don't Summarize". Thanks for the help!

Message 4 of 5
1,755 Views
Pragati11
Super User
Super User

‎04-04-2022 07:36 AM

Hi @Dbstedman ,

 

Whenever you move certain columns to Power BI table visual, if they are of numeric type they should summarise themselves by default to SUM.

What are the data-types of all the columns in your screenshot above?

 

Best Regards,

Pragati Jain


MVP logo


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!!

Message 2 of 5
1,796 Views
Dbstedman
New Member
In response to Pragati11

‎04-04-2022 07:52 AM

The first column should be text and the next three are whole numbers.

Message 3 of 5
1,759 Views

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All