Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Split a table over two pages

I have constructed a report that has a number of tables on the page, designed to mimic a PowerPoint slide. In some cases there are too many rows in some tables, so they cannot fit in the space available on a single page. It would be great if those tables could be split over two or more pages to accommodate excessive data. For instance, a table that has five rows is split to show two rows on the first page and the remaining three rows on the second page.

 

Is there a way to do this? I looked at using filters but there is no appropriate element on which to base the filter. 

 

Thanks

Steve

Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Please try to create a rank measure:

    Measure = RANKX(ALLSELECTED(query),CALCULATE(SUM(query[Index])),,ASC)

    Then apply it to visual-level filter and the two pages show:

    Here is the pbix file.

    pbix 

     

    Best Regards,

    Giotto Zhi

5 Replies

  • vivran22's avatar
    vivran22
    Community Champion
    6 years ago

    Hi,

     

    I have created a sample solution file here

     

    Regards,

    Vivek

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions help users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    Hi,

     

    According to your description, you can add an index column in Query Editor.

    After Apply&Close, add new report pages, copy the table visual you want to paginate and add a page filter to each page by filtering column Index.

     

    Hope this helps.

     

    Giotto Zhi

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you for the proposed solution. It would work if the rows to be shown were in sequential order, but they are not. The table is filtered to exclude some rows so an index column becomes unworkable.

       

      I have built a abbreviated version of the table. It can be found here. I want to show the table split over two pages with the first two rows on page 1 and the other two rows on page 2.

       

      Thanks

      Steve

      • v-gizhi-msft's avatar
        v-gizhi-msft
        Community Support
        6 years ago

        Hi,

         

        Please try to create a rank measure:

        Measure = RANKX(ALLSELECTED(query),CALCULATE(SUM(query[Index])),,ASC)

        Then apply it to visual-level filter and the two pages show:

        Here is the pbix file.

        pbix 

         

        Best Regards,

        Giotto Zhi