Forum Discussion

axata's avatar
axata
Helper I
8 years ago

Aggregation in Paginated PowerBI Report

Hey, 

 

I have created a pagination report for an embedded application using PowerBI Pro. Below is the reports snap which I have created:

 

paginationtotal.PNGHow to show Total on the last page in the paginated report?

 

 

 

I wanted to show Grand Total on the last page for all table data. Is it possible to use the aggregate function on the paginated report and if yes, then how to show the total of all table data on the last page of report?

 

Thanks

Need Help

5 Replies

    • axata's avatar
      axata
      Helper I
      8 years ago
      Yes, I have used Grid to show all data on report with pagination.
      But I wanted to show all data with Grand Total on last page.
      Please let me know if you can help with it.
      • GilbertQ's avatar
        GilbertQ
        Super User
        8 years ago
        Hi there,

        I think that the current report will not be able to do this.

        You would need to change it back to the table or matrix custom visual