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

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

Pedro_Ziggy — Thu, 13 Jun 2024 22:21:38 GMT

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:

Result:

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..).

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

Anonymous — Fri, 14 Jun 2024 01:51:20 GMT

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.

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

Pedro_Ziggy — Fri, 14 Jun 2024 13:23:23 GMT

Hi Anonymous,
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!