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 availa...
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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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