Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Power BI Query

  • 23-11-2018 02:44PM
    #1
    trafficlight
    Registered Users, Registered Users 2 Posts: 178 ✭✭


    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


Comments

  • #2
    Ranjo
    Registered Users, Registered Users 2 Posts: 447 ✭✭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.


  • #3
    callaway92
    Registered Users, Registered Users 2 Posts: 15,110 ✭✭✭✭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



  • #4
    BrookieD
    Registered Users, Registered Users 2 Posts: 2,704 ✭✭✭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



  • #5
    callaway92
    Registered Users, Registered Users 2 Posts: 15,110 ✭✭✭✭callaway92


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

    Thanks man, will do



Advertisement