Forum Discussion
Page Breakup in Power BI Report Builder
Hello,
I have a vertical Bar Chart in my paginated Report and because this chart is very long, it is split up over many pages. The Problem that I have is, that at the Split up happens right through the charts / labels. How can i change this?
If your chart has too many categories and doesn't fit in one page I think it will be split wherever it reaches the bottom border.
Have you already tried to change the bottom border to see if it cuts in a different place?
Hi LaurenzR,
Paginated Reports do not allow you to control exactly where a chart is split across pages. If a chart is taller than the page, Report Builder will break it at the page boundary, which can cause bars or labels to be cut off. There is no dynamic page-break logic for charts that can prevent this. As a result, you cannot achieve a clean split between bars using the standard chart object. To avoid this, you can redesign the visual by splitting the category axis into several smaller charts, using a tablix instead of a long chart, or grouping the data so each page shows a set number of categories. These options help prevent mid-bar cuts, since the rendering engine does not automatically handle page breaks within a single large chart.
Thank you
Sahasra.Hi, thanks for all the help. Unfortunately i did not find a way to use the bar chart visual in a way without any problems at the page break. For this reason i just took a matrix where the bar chart is in one column and the Series is in another column. this works ok but there is not a nice way to dynamicly set the x-Axis to the same maximum value for all series. For the x-Axis I just divided the total revenue of all elements by 4 so that the Axis is not to big in comparison to the data bars.
9 Replies
v-sgandrathiCommunity Support
Hi LaurenzR,
Paginated Reports do not allow you to control exactly where a chart is split across pages. If a chart is taller than the page, Report Builder will break it at the page boundary, which can cause bars or labels to be cut off. There is no dynamic page-break logic for charts that can prevent this. As a result, you cannot achieve a clean split between bars using the standard chart object. To avoid this, you can redesign the visual by splitting the category axis into several smaller charts, using a tablix instead of a long chart, or grouping the data so each page shows a set number of categories. These options help prevent mid-bar cuts, since the rendering engine does not automatically handle page breaks within a single large chart.
Thank you
Sahasra.- ChielFaber
Super User
You can prevent a chart from breaking across pages in Power BI Report Builder by placing it inside a rectangle and adjusting its pagination settings. A chart inside a tablix cell will often split, so using a rectangle is the safest container.
Do this:
Insert a Rectangle and place your chart inside it.
Select the Chart → Properties:
KeepTogether = True
PageBreak → Disabled = True
Select the Rectangle → Properties:
KeepTogether = True
PageBreak → Disabled = True
Make sure the rectangle (and chart) fits within the page size.
Turn off any automatic resizing on the chart to prevent it from expanding beyond the page.
With this setup, the chart will render as a single block and will no longer split across pages.
Hi Thanks for the answer, but the chart stil split across pages und get cut off.
To clarify, I want to export the report as a PDF and the chart should be able to split across pages but the split should not go throug a bar directly. It should be a clean split so that no data is lost / not readable
R1k91is that a paginated report or a power bi report?
if it's a paginated one, how big is the chart? is it filling the entire page or just a part of it?
Hi Thanks for the answer, but the chart stil split across pages und get cut off.
To clarify, I want to export the report as a PDF and the chart should be able to split across pages but the split should not go throug a bar directly. It should be a clean split so that no data is lost / not readable
- v-sgandrathi
Hi LaurenzR,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum! Hi, thanks for all the help. Unfortunately i did not find a way to use the bar chart visual in a way without any problems at the page break. For this reason i just took a matrix where the bar chart is in one column and the Series is in another column. this works ok but there is not a nice way to dynamicly set the x-Axis to the same maximum value for all series. For the x-Axis I just divided the total revenue of all elements by 4 so that the Axis is not to big in comparison to the data bars.
