Share via

Pivot Table not showing values in Data Source.

Anonymous
2020-12-18T19:19:30+00:00

I am sourcing pivot table data from a table created using power query. I don't get the values from the source table, rather I get a count. Changing the field propertes to sum results in zeros. When I put the value fields in the row, I get the values, but as rows. What am I missing?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2020-12-18T19:49:40+00:00

I found the problem. When sourcing data from a spreadsheet through Get & Transform, check the formatting. Sometimes spreadsheets are formatted as text even though they appear to be numbers. Some providers of data, particularly purveyors of public data are not careful about how they format the sheets. Make sure to check the formatting before you Load & Go to ensure the formats are numerical, not text.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-12-18T23:10:27+00:00

    Hi Jeff,

    Glad to hear that problem is resolved at your end and appreciate for your efforts to take your time share the answer in the forum, which helps other members in the community who encounters with same scenario. In future, if you have any further concerns, please feel free to post a new thread in this community.

    Have a good weekend!!

    Best Regards,

    Chitrahaas

    Was this answer helpful?

    0 comments