The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I'm trying to create a Power BI paginated report with graphs. It looks fine when I preview in normal mode, but I can only see a portion of the visual in the print layout.
I've tried adjusting font sizes, dynamicheight and dynamicwidth, but that hasn't made any difference.
I've tried different visuals, but they all have the same problem. I have other reports that use list data regions and these work fine.
Normal layout:
Print layout:
Solved! Go to Solution.
1. Set Fixed Chart Size:
Avoid auto-sizing. Manually set the chart’s `Width` and `Height` in inches (e.g., 6in x 3in).
2. Check Page & Body Size:
Ensure Body Width + Left/Right Margins ≤ Page Width.
(e.g., for A4: 8.3in width – 1in margin each side = max 6.3in body width)
3. Use Containers:
Place visuals inside a Rectangle or Table cell with fixed size to maintain layout.
4. Disable CanGrow/CanShrink:
Set `CanGrow = False` and `CanShrink = False` for charts and containers.
5. Test with PDF Export:
Use PDF export to confirm layout, as print preview can behave differently.
Thanks for the suggestions. The one that worked for me was generating the PDF. The graph looks fine in the final output, just not in the print preview.
1. Set Fixed Chart Size:
Avoid auto-sizing. Manually set the chart’s `Width` and `Height` in inches (e.g., 6in x 3in).
2. Check Page & Body Size:
Ensure Body Width + Left/Right Margins ≤ Page Width.
(e.g., for A4: 8.3in width – 1in margin each side = max 6.3in body width)
3. Use Containers:
Place visuals inside a Rectangle or Table cell with fixed size to maintain layout.
4. Disable CanGrow/CanShrink:
Set `CanGrow = False` and `CanShrink = False` for charts and containers.
5. Test with PDF Export:
Use PDF export to confirm layout, as print preview can behave differently.
User | Count |
---|---|
5 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
6 | |
4 | |
4 | |
3 | |
2 |