Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Create Total per day

I'm trying to get all of the values into a single line in a table, this is one day's worth of sales values but it seems to split them into individual transactions, is there any way to group all of the transactions?

 

 

Thanks in advance,

 

Paul

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.


  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Anonymous 

     

    I would use the matrix chart for this purpose, I believe what you are using is Table chart.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Anonymous 

    You can modify the aggregate mode to 'sum' on 'lineNett' field, then power bi will auto-summary your records based on the current category group date. (create a table visual with date and value fields, then right-click on value field to setting aggregate mode to sum)

    Work with aggregates (sum, average, and so on) in the Power BI service 

    Regards,

    Xiaoxin Sheng