Forum Discussion

jeggen's avatar
jeggen
Helper II
6 years ago
Solved

Overflow table content into a second table

I export my report to a PDF to share with team members, so anything that has a scroll bar essentially just cuts off the content. There is enough room on the screen for everything, but with the horizo...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI jeggen ,

    You can add an index column to your table, then write a page column to group records based on index filed.
    After these, you can apply page on visual level filer to control table visual display different page records.

    Page = 
INT ( ( 'Table'[Index] - 1 ) / 10 ) + 1

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi jeggen ,

Nope, current power bi does not support this, maybe you can submit an idea for this requirement.

Regards,

Xiaoxin Sheng

jeggen's avatar
jeggen
Helper II
6 years ago

Is there a way to manually do this? I know how to format one table to show only the top x records (35 is what fits.) I only see a way to do the top x or bottom x records, but is there a creative way to show the bottom y records where y = total records - x?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI jeggen ,

    You can add an index column to your table, then write a page column to group records based on index filed.
    After these, you can apply page on visual level filer to control table visual display different page records.

    Page = 
INT ( ( 'Table'[Index] - 1 ) / 10 ) + 1

    Regards,

    Xiaoxin Sheng