Power BI Query

trafficlight

Hey,

I am wondering does anyone use Power BI for creating reports etc.

I am having difficulty at the moment with a Bar chart where a new column of data has been entered in the source excel document.

When I try to add this information to the existing chart to update - the data values default to "Count" and I cannot see any option to change them to " Sum"

Any Ideas?

Thanks

Ranjo

In the panel to the right, where you dragged the column into the fields, you can change the aggregation from COUNT TO SUM. It's the small arrow on the field name.

callaway92

Completely off-topic but can't find best location - Is there anybody here that has experience in PowerBI (or know someone that does) that could help out with what I'd assume would be a small project for someone that knows it well?

It's basically a need for reports to automatically create when I export a CSV (it's for Match/Player Reports for Sports)

EDIT: Also open to the same for Tableau so long as the reports can be exported as PDF from it

BrookieD

https://www.boards.ie/discussion/comment/118610125#Comment_118610125

PM me some details, I use PowerBI and have a DA100 so might be able to help you

callaway92

https://www.boards.ie/discussion/comment/118612978#Comment_118612978

Thanks man, will do