Forum Discussion

khanna's avatar
khanna
New Member
2 years ago

Split a large table over to multiple pages

Hi,

Am new to Power BI, is it possible to split a large table overto multiple pages?

Or alrtenatively use the Paginated reports to display RAG status (Conditional Formatting)

p.s. do not have access to Power BI Report Builder

Need Help

3 Replies

  • khanna's avatar
    khanna
    New Member
    2 years ago

    Thanks PijushRoy This is insightful, but what i'm trying is that the table should split over multple pages in Power BI Service dynamically

     

    The stakeholder simply wants to export the report to a PDF from POwer BI service and wants the table split over by automatically. 


    e.g. if there are 50 rows in table,the Power BI service should split it to 5 table by itself and once exported to PDF, it should be spread on 5 pages 

    • PijushRoy's avatar
      PijushRoy
      Icon for Community Champion rankCommunity Champion
      2 years ago

      Hi khanna 

      As you do not have access to Power BI Report Builder, please try the below steps

      Create 5 Pages in the report
      5 pages contain 5 Table
      Each table uses the page level filter for Top 10, Top 11 to 20, Top 21 to 30, Top 31 to 40 and 41 to 50
      https://www.youtube.com/watch?v=JLK2e0k8OBE

       

      If solved your requirement, please mark this answer as SOLUTION.
      If this comment helps you, appreciate your KUDOS

      Thanks
      Pijush