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 certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
728 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
724 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
682 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
684 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
725 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
688 Views

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

View All