Hi All,I would like to ask some help about the Power BI Paginated Report Builder.Image to share: https://ibb.co/MZ6LbVp [Some areas are blacked out due to data protection] I highlighted some of the areas on the screenshot, however I have a few queries:- On the left side there is a huge blank area. I looked for Paddings or Margins but there is nothing like it under the properties- On the right side the chart should go until a 100, because the chart is a 100% Column Chart. It stops about 80%.- On the top the legend is not aligned to the middle of the chart area.- On the bottom I added the X asis, however it is not visible. Without that some of the column charts wouldn't be visible. Please can someone advise which chart properties should I check, and are there any Microsoft Documentation about it?Before advising me to google it I tried without any luck. Thank you.

Solution:After raising a ticket with Microsoft they were able to reproduce the problem.The problem came from the inherited value of Scalie and Layout under the display settings.I had the scaling value set for 150%. After changing it to 100% the Printing layout and Preview shows the same output, no issue with the Axis Titles or the Legend not showing.Thank you all for your help.

This is a setting for your computer, not in Power BI Report Builder. You can get to it by searching "display settings" in your start menu. Note that you'll need to resart the program for the scaling setting to be updated.

Hey Anonymous Paginated Reports can throw up things like this, I've recently started using them and had a few issues when I've not set my page up correctly. The Power BI Paginated content list below is great, as is the Power BI Paginated Reports in a Day video series on YouTube https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi I can't check out your image just now as the link is blocked on my company network, will try to check it later.

Hi Daviejoe,Thank you for the quick reply. I done the online 1 day paginated report training, but they are not mentioning this kind of issue.It is really strange to be honest, if I would have the right properties then I would be able to easily amend the objects.There might be a different approach, if someone knows how to deal with it would mean a lot 🙂

I think the 100% stacked bar chart is working, it does seem to be adding up to 100%.

Paginated Report Builder - Chart does not fully generate within the designated Chart Area

16 Replies

Daviejoe
Memorable Member
6 years ago
Hey Anonymous

Paginated Reports can throw up things like this, I've recently started using them and had a few issues when I've not set my page up correctly.

The Power BI Paginated content list below is great, as is the Power BI Paginated Reports in a Day video series on YouTube

https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi

I can't check out your image just now as the link is blocked on my company network, will try to check it later.
- Anonymous
  Not applicable
  6 years ago
  Hi Daviejoe,
  Thank you for the quick reply. I done the online 1 day paginated report training, but they are not mentioning this kind of issue.
  It is really strange to be honest, if I would have the right properties then I would be able to easily amend the objects.
  There might be a different approach, if someone knows how to deal with it would mean a lot 🙂
  - Daviejoe
    Memorable Member
    6 years ago
    I think the 100% stacked bar chart is working, it does seem to be adding up to 100%.
dax
Community Support
6 years ago
Hi Anonymous ,

It looks like you are use print layout instead of preview, right?

On the left side there is a huge blank area. I looked for Paddings or Margins but there is nothing like it under the properties

You need to check whether you put chart close to left border of design pane?

On the right side the chart should go until a 100, because the chart is a 100% Column Chart. It stops about 80%.

According to your chart, I think a line will be 100%, you could view it in chart, all value in a line is 100%, so it will show 80% in last line(20% is Active)

On the top the legend is not aligned to the middle of the chart area

You need to make sure the chart area whether include Y-axis

On the bottom I added the X asis, however it is not visible. Without that some of the column charts wouldn't be visible.

I could view it in your chart, did you mean that this part can't view in your chart?

By the way, if possible, could you please upload your rdl file(create this report with virtual data instead of real data) and some sample file ? Then I will try to check and modify it in my environment.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Anonymous
  Not applicable
  6 years ago
  Hi Zoe,
  Yes, I am using the print view. In the preview it shows correctly, but the issue is with the print view. It is causing a problem when I try to make a print of it.
  I added some cleared manual data and I removed the confidential one. The other difference is that I didn’t add a manual colouring to the chart and legend so Passed tasks shows red instead of green. I shared the report at the end of this message.
  Left side blank area:
  I checked the sizes and everything is within the page size. The page is an A4 landscape (29.7x21cm with 1cm margins) and the body width is 27cm. I tried to resize the chart, but the issue is still the same on the print view. The preview is OK.
  Missing area between 80% and 100%
  Preview shows okay with no issue:
  
  On the print preview the chart seems to have a left and top margin causing the X axis title and the end of the chart disappear. I am starting to think about an inherited value from somewhere, but from where...
  On this one I changed the alignment of the legend to the right. As you can see it disappeared, however the end of the chart is pushed back a bit. (print view)
  
  Top Legend not aligned
  In print view it seems that the left and top margin pushes the legend to the right a bit.
  
  Bottom X axis
  Apologies, I meant X axis title. The X axis is visible.
  
  Report File
  Please find the link for it below:
  https://drive.google.com/file/d/1dTv77hrpduppoLrKlqmfUZds7JXM40OT/view?usp=sharing
  
  Thank you for your help.
  Zsolt
  - dax
    Community Support
    6 years ago
    Hi Anonymous ,
    
    It seems that you send a correct sample to me, I open this in my environment, I find which works well. I don't modify it
    
    Best Regards,
    Zoe Zhi
    
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Daviejoe
Memorable Member
6 years ago
With regards to the Legend, select it and right click on it, then go to Legend Properties, this should allow you to select the Legend position you want.
Daviejoe
Memorable Member
6 years ago

- On the left side there is a huge blank area. I looked for Paddings or Margins but there is nothing like it under the properties
Have you accidently left a shape there?. Check your margin settings?
Anonymous
Not applicable
4 years ago
Hi experts,

I tried to generate a paginated report, all things were going well. But whenever I tried to add chart in the report it doesn't fully visible in the design and print layout view. Only some part (around 25% is visible ).

I have attached the screenshot please have a look.

any response would be highly appreciated.

Thanks