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

vivran22's avatar
vivran22
Icon for Community Champion rankCommunity 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!