Forum Discussion

Dbstedman's avatar
Dbstedman
New Member
4 years ago
Solved

Data not Summarizing

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

 

Need Help
  • Pragati11's avatar
    Pragati11
    4 years ago

    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?

     

4 Replies

  • Dbstedman's avatar
    Dbstedman
    New Member
    4 years ago

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

  • Pragati11's avatar
    Pragati11
    Super User
    4 years ago

    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?

     

    • Dbstedman's avatar
      Dbstedman
      New Member
      4 years ago

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