Change the size of a report page (Tutorial)
In the previous article and video you learned about two different ways to control page display in Power BI reports: View and Page Size. Page view and Page Size are available in both Power BI service and Power BI Desktop, and look and function amost the same, but for this tutorial we're using Power BI service.
- Power BI service
- Retail Analysis Sample report
First, let's change the page View setting
Open the report in Reading View or Editing View and select the report tab for New Stores. By default, this report page is displayed using the Fit to Page setting. In this case, Fit to Page displays the report page without scrollbars, but some of the detail and titles are too small to read.
Make sure that no visualizations are selected on the canvas. Select View and review the display options.
In Reading view you'll see this.
In Editing view you'll see this.
Let's see how the page looks using the Actual size setting.
Not great, the dashboard now has double scrollbars.
Switch to Fit to Width.
Looks better, we now have scrollbars but it's easier to read the detail.
Change the default view for a report page
If you're a report creator, you can change the default view for your report pages. When you share your report with others, the report pages will open using the view you've set. Report consumers will be able to change the view, but won't be able to save their changes once they exit out of the report.
On the New stores page of the report, switch back to Actual size view.
On the District Monthly Sales report page, set View to Fit to width.
On the Overview report page, leave the default View setting.
Now save the report by selecting File > Save. The next time you open this report, the pages will display using the new View settings. Let's go see.
Select the name of the current workspace from the top navbar to return to that workspace.
Select the Reports tab and choose the same report (Retail Analysis Sample).
Open each page of the report to see the new settings.
Now, let's explore the page size setting
The page size settings are only available in Editing view, so you must have edit (creator) permissions to the report to change the page size settings. If you've connected to any of our samples, you'll have creator permissions to those reports.
- Open the "District monthly sales" page of the Retail Analysis sample in Editing View.
- Make sure that no visualizations are selected on the canvas. In the Visualizations pane, select the paint roller icon .
Select Page size > Type to display the page size options.
Select Letter. On the canvas, only the contents that fit within 816 x 1056 pixels (Letter size) remain on the white portion of the canvas.
Select Page size 16:9 ratio.
The report page displays using a ratio of 16 wide by 9 high. To see the actual pixel size being used, take a look at the greyed out Width and Height fields (1280x720). There is a lot of empty space around the report canvas; this is because we previously set View to "Fit to width".
- Continue exploring the Page Size options.
Use page View and Page Size together
Use page View and Page Size together to create a report that looks its best when shared with colleagues or embedded in another application.
In this exercise, you'll create a report page that will display in an application that has space for 500 pixels wide by 750 pixels high.
Remember in the previous step we saw that our report page is currently displaying at 1280 wide by 720 high. So we know that we'll need to do a lot of resizing and rearranging if we want all of our visuals to fit.
Resize and move the visuals so that they fit in less than half of the current canvas area.
- Select Page Size > Custom.
Set Width to 500 and set Height to 750.
Tweak the report page so that it looks its best. Switch between View > Actual size and View > Fit to page to make adjustments.
More questions? Try the Power BI Community