Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Pedro_Ziggy
Regular Visitor

[Power BI Report Builder] - Empty/white spaces in the report when an object is hidden

Hello Community,

Description of the problem: I am working on a paginated report in which some objects (tablix / textboxes) have logic for hiding and showing themselves. The problem is that when an object is hidden, it leaves an empty space that looks unprofessional when generating to PDF (the document stretches unnecessarily).


Example:

Pedro_Ziggy_0-1718317152271.png


Result:

Pedro_Ziggy_1-1718317218933.png


My question: how to reduce white spaces while maintaining the logic of hiding tablixes/textboxes (later in the report I got more of the same situations).


Alternatives (internet research): breaking the report into smaller ones that will precisely cover specific cases for specific regions or using sub-reports (it will be very difficult to maintain it..).

1 ACCEPTED SOLUTION
v-rongtiep-msft
Community Support
Community Support

Hi @Pedro_Ziggy ,

To reduce white spaces while maintaining the logic for hiding objects, consider the following approach:

This property allows you to control whether to preserve or eliminate white space at the end of a report. Setting this property to `True` can help reduce the white spaces caused by hidden objects.

Troubleshoot paginated report execution issues - Power BI | Microsoft Learn

 

Placing the objects you might hide/show within rectangles can help manage the layout more effectively. Rectangles can serve as containers that group items together, and when items within a rectangle are hidden, the rectangle can help in reducing the white space.

Empty and null data points in Power BI paginated report charts - Power BI | Microsoft Learn

Add empty points to a chart in Power BI paginated report - Power BI | Microsoft Learn

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-rongtiep-msft
Community Support
Community Support

Hi @Pedro_Ziggy ,

To reduce white spaces while maintaining the logic for hiding objects, consider the following approach:

This property allows you to control whether to preserve or eliminate white space at the end of a report. Setting this property to `True` can help reduce the white spaces caused by hidden objects.

Troubleshoot paginated report execution issues - Power BI | Microsoft Learn

 

Placing the objects you might hide/show within rectangles can help manage the layout more effectively. Rectangles can serve as containers that group items together, and when items within a rectangle are hidden, the rectangle can help in reducing the white space.

Empty and null data points in Power BI paginated report charts - Power BI | Microsoft Learn

Add empty points to a chart in Power BI paginated report - Power BI | Microsoft Learn

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-rongtiep-msft
Thank you for your contribution.

EDIT: Using a rectangle and grouping, adding individual objects inside it + using an expression on the rectangle to hide/show solved the problem.

Many thanks!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors