Split a table over two pages

[Anonymous]

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

[v-gizhi-msft]

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]

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 · Accepted solution]

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

[Anonymous]

Thank you for the solution. Another possibly more tricky question. In the same report, I have columns that are text only and from time to time the amount of text in a row is too large for the space provided on the first page of the report.  Is it possible to show some of the text in a single row on one page and the remainder on a second page?

Thanks

Steve

[vivran22]

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!