Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
axata
Helper I
Helper I

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

5 REPLIES 5
GilbertQ
Super User
Super User

Hi there,

Are you using a Custom Visual in the above?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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.

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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.

Hi there,

I don't think that it is currently possible




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors