The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a paginated report containing 13 different tables (all needed). If the they show all of the data, everything ends up being about 10 pages. I put everything into a rectangle container and that has helped with some of the condensing, but there are still large blank spaces under the tables until they get to the next row of tables (see image). Does anyone happen to know a good way of eliminating the extra space so when one table ends the next one would begin only a few cm below it?
Thanks for any help.
Hi @Anonymous ,
While I can't tell exactly what is causing your problem, I can give you some advice:
Ensure that the properties of the tables and the rectangle container are set to keep contents together without unnecessary breaks. You can find this setting under the properties pane when you select the table or rectangle.
Make sure that the rectangle is not larger than it needs to be. Adjust the height of the rectangle to be just a bit larger than the tables it contains.
Check if there is any padding set on the tables or within the rectangle that might be causing the extra space. Reduce the padding to a minimum value that still maintains the report's readability.
If you want the tables to stay close to each other, you can use the 'KeepTogether' property on the table rows to ensure that they don't break across pages unnecessarily.
If the tables have varying row counts, consider using dynamic visibility to hide rows that are not needed, which can help reduce the space.
Ensure that the page breaks are set correctly for each table. You might need to adjust where the page breaks occur to optimize space.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Unfortunately, I am still getting the stepped tables rather then having the next table start right after where one ends. Using the Tablix options "Keep together on one page if possible", andProperties "KeepTogether" = true, the rectangle was ~1px away from the edges of the tables, as well as change the Padding from 2pt to 0pt was not able to condense the tables. The rows are all needed so I can not change them that way.