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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.