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. Now let's try it ourselves.
First, let's change the page View setting
Open a report in Reading View or Editing View. This example uses the "New Stores" page of the Retail Analysis sample. This 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
All Power BI reports default to Fit to page view. But what if you want this report page to always open in Actual size view?
On the New stores page of the report, switch back to Actual size view.
Save the report with a different name by selecting File > Save as. You now have 2 copies of this report; in the original report, New stores will continue to open in the default view but in the new report it will open in Actual size view. 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 new report you just created (it will have a yellow asterisk).
The report opens in Actual size view!
Now, let's explore the page size setting
The page size settings are only available in Editing view. To open a report in Editing view you must have owner permissions for the report. If you've connected to any of our samples, you'll have owner 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.
If we change View to "Fit to Width," our canvas now displays only the page contents that fit into the letter size.
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.
Using page View and Page Size together
Use page View and Page Size together to create a report that looks its best when 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.
Read more about reports in Power BI
More questions? Try the Power BI Community