Forum Discussion
Paginated Report Issue
Hi,
I am using a powerbi data source to build a paginated report but Paginated report is omitting few blank rows(ones which has incomplete data in a row) but it looks fine in powerbi report with both blanks and non blanks.
Paginated report is only considering complete data in a row but not all the records
Any solution for this?
Hi prashanthjjk
The following is for your reference:
If null values or null fields are displayed in the chart of a paged report, the chart may not behave as expected. Null values are handled differently depending on the chart type.
- If the chart type is a linear chart type, null values are displayed as spaces or "gaps" in the chart. To display null values, you must add a null placeholder. For more details, you can read related document link: Add empty points to a chart in a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn
- If the chart type is a non-linear chart type, such as polar, pie, doughnut, funnel, or pyramid charts, the null value will be omitted from the display on the chart.
- If the chart type is a shape chart, the null value is omitted.
For more details, you can read related document link: Empty and null data points in paginated report charts - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi prashanthjjk
The following is for your reference:
If null values or null fields are displayed in the chart of a paged report, the chart may not behave as expected. Null values are handled differently depending on the chart type.
- If the chart type is a linear chart type, null values are displayed as spaces or "gaps" in the chart. To display null values, you must add a null placeholder. For more details, you can read related document link: Add empty points to a chart in a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn
- If the chart type is a non-linear chart type, such as polar, pie, doughnut, funnel, or pyramid charts, the null value will be omitted from the display on the chart.
- If the chart type is a shape chart, the null value is omitted.
For more details, you can read related document link: Empty and null data points in paginated report charts - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.