Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Dear Community,
I have a complex report that contains several visuals, tables, KPIs. I need to create a PDF export for a number of clients (data filtered for each). Depending on filtering the data usually don't fit into the tables so a scrolling bar appears. When I export the report it actually creates a screenshot, so scrolling tables get truncated, not all data is visible.
My questions:
1.) Is it possible to automatically resize tables to contain all data and not to add scrolling?
2.) If yes, can it be done to pages as well?
3.) Is there any other way to get around the above described problem and export a report that contains all data (no scroll bars)?
Thanks for your help, best regards
Adam
Hi @Anonymous,
I've had the same issues as you and to my knowledge there is no way to dynamically resize tables/pages depending on the content inside.
I generally work around this by grouping dimensions, for example displaying top 10 customers and then rank 10+ grouped as "Other".
Another way around it would be having different sized presets of the same report. You could have bookmarks that change to size of the tables on each page but sadly you still wont be able to resize the pages.
If you figure out any other solutions to this please share as I would be rather interested!
Br,
Johannes
Hi Johannes,
Thanks for your kind reply. I'll let you know if I get so lucky to learn a better way than what you have described.
Best regards,
Adam
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 133 | |
| 88 | |
| 85 | |
| 68 | |
| 64 |