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

v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity 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