cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
prateekraina
Memorable Member
Memorable Member

Create Reports with Vertical / Horizontal scroll bar on pages

Hi Guys,

 

I have noticed that while creating reports people are confused and not really able to make full use of the Custom page size option available in Power BI Desktop .

 

There are scenarios where you want to create single page reports with lots of visuals. What people do is that they increase the Page Size but every thing is crammed inside that space which makes people looking reports on small screens difficult to see numbers.

 

To keep in mind such scenarios, here are the steps you need to follow to create a report with vertical/horizontal/both scroll bar:

 

1. In View tab, click on Page View and set it to Actual Size. This setting is applicable only to that specific page.
 
              Solution1.PNG

2. Now in Format option of the page, change Page Size to Custom and increase Page width/height. You will get the desired scroll bar.

3. Start adding visuals to the page and see the magic!!
   
         Final OutputFinal Output

 

 

Prateek Raina

5 REPLIES 5
Astu
New Member

I am working on wide table of 14 columns , so  My vertical was there , but  horizonal scroller  was not showing , so

first click on the table,

go to format  and change the Vertical Alignment to middle, 

and page size to custom, and change the pixels size to desired size , on my case since I have wide table , I set it to width 1800 and height 1800, both horizontal and vertical scroller show up! 

 

 

Ani26
Helper III
Helper III

Hi @prateekraina 
Thank you so much for sharing the idea. It indeed helped a lot.

 

Thank you,

Anish

ervinaymishra
Frequent Visitor

How I can change page tab view to vertical scroll or show parallel.If I am having two page in my report then how I can view both page at the same time parallelly.

Hi @ervinaymishra,

 

As of now, You cannot see two pages parallely at same time.

 

Prateek Raina

GuyInACube
Microsoft
Microsoft

One word of caution on this. I've seen examples of a report that used the approach and caused some performance related issues. With adding a ton of visuals, it may take time for all of them to load completely. In the example I saw, it was about 120 visual that kept going vertically.

 

I would question the need for doing this from a Power BI perspective. How much data would be useful to the user? Would it make sense to revisit the report and refactor into different pages that are more targeted? Would a different reporting solution make more sense - such as a Paginated report with SSRS/Power BI Report Server? 

Adam W. Saxton | Microsoft Employee | Business Intelligence
@GuyInACube | youtube.com/guyinacube

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors