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"
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.
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
