Aggregation in Paginated PowerBI Report

[axata]

Hey, 

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

How 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

[GilbertQ]

Hi there,

Are you using a Custom Visual in the above?

[axata]

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]

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

[axata]

Hi, 

I have tried with the table or matrix visuals as well.

But, In a table or matrix custom visual is not providing the pagination facility. It only gives the Grand Total at the end.

I am looking for a visual which provides both, pagination with Grand Total on the last page.

[GilbertQ]

Hi there,

I don't think that it is currently possible