Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
pang22
Helper III
Helper III

change to scroll bar to up & down

Hello,

 

I have a matrix in Power BI report view.

How to change the matrix scroll bar to up & down instead of left to right.

And fit the matrix to the view?

 

pang22_0-1699500575809.png

 

3 ACCEPTED SOLUTIONS
johnyip
Super User
Super User

@pang22 The scroll bar automatically appears whenever your matrix is not able to show all the columns/rows.

 

you will need to resize your matrix to control the appearance of the scroll bar.

 

 



Please mark my post as the solution if this answers your question!
Appreciate your Kudos !!

View solution in original post

Ritaf1983
Super User
Super User

Hi @pang22 
The scrollbars in matrices provide the functionality to access 'invisible' rows or columns due to limited space within the visual size
If there is not enough place for all rows  there are vertical scrolls:

Ritaf1983_0-1699501774679.png

If the lack of place is for columns, horizontal:

Ritaf1983_1-1699501880646.png

or both :

Ritaf1983_2-1699501906371.png

The size and structure of the matrix you create determine which scrollbars will appear; it's not a format option that we can modify.

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

Uzi2019
Super User
Super User

Hi @pang22 
You can reduce the size of your columns like reduce the columns size , reduce the header size to min (8). Try to adjust the all column in single view to avoid scrolling. 
Or Just do the following if you dont want scrolling.
Set the canvas to custom 
Increase the width size to 2000 to more based on your scrolling. 

Uzi2019_0-1699508066049.png

Adjust your visual to the width size of your page. 
then set fit to width option from view tab

Uzi2019_1-1699508184134.png

 

I hope this will not have scrolling from left to right.

 

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

View solution in original post

3 REPLIES 3
Uzi2019
Super User
Super User

Hi @pang22 
You can reduce the size of your columns like reduce the columns size , reduce the header size to min (8). Try to adjust the all column in single view to avoid scrolling. 
Or Just do the following if you dont want scrolling.
Set the canvas to custom 
Increase the width size to 2000 to more based on your scrolling. 

Uzi2019_0-1699508066049.png

Adjust your visual to the width size of your page. 
then set fit to width option from view tab

Uzi2019_1-1699508184134.png

 

I hope this will not have scrolling from left to right.

 

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
Ritaf1983
Super User
Super User

Hi @pang22 
The scrollbars in matrices provide the functionality to access 'invisible' rows or columns due to limited space within the visual size
If there is not enough place for all rows  there are vertical scrolls:

Ritaf1983_0-1699501774679.png

If the lack of place is for columns, horizontal:

Ritaf1983_1-1699501880646.png

or both :

Ritaf1983_2-1699501906371.png

The size and structure of the matrix you create determine which scrollbars will appear; it's not a format option that we can modify.

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
johnyip
Super User
Super User

@pang22 The scroll bar automatically appears whenever your matrix is not able to show all the columns/rows.

 

you will need to resize your matrix to control the appearance of the scroll bar.

 

 



Please mark my post as the solution if this answers your question!
Appreciate your Kudos !!

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors