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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
ozo909
Regular Visitor

Display settings for multi size monitors

Hi, I have a report which is a just a single table (with many columns) that expands the whole page, like an Excel table. This is viewed on Windows desktops in the browser and the desktops have different size monitors.

 

I'm try to configure it so for wider monitors it will show more table columns, but when I stretch out the browser it zooms the text and doesn't show more columns. I've tried different combinations of Page View settings and Canvas Settings, but nothing works.

 

I saw there is a Responsive setting but it's greyed out on the Table visual.

 

Any tip would be most appreciated.

1 ACCEPTED SOLUTION
ozo909
Regular Visitor

I found the solution to this. As per @amitchandak advice, set the canvas width, but also have your Page View set to Actual Size. Drag your table out as wide as the canvas. Then play around with column & values text size, column wrapping and auto-size width, until it's right.

View solution in original post

3 REPLIES 3
ozo909
Regular Visitor

I found the solution to this. As per @amitchandak advice, set the canvas width, but also have your Page View set to Actual Size. Drag your table out as wide as the canvas. Then play around with column & values text size, column wrapping and auto-size width, until it's right.

ozo909
Regular Visitor

Hi @amitchandak , when I do that it's ok for larger monitors, but on smaller monitors it makes the font size tiny, to fit all the columns in. Is there a setting to lock the font to one size. 

 

Smaller monitors should have the horitizonal scrollbar to see all columns, and larger monitors shouldn't need to have a horitizonal scrollbar.

 

I hope that makes sense.

amitchandak
Super User
Super User

@ozo909 , You should be able to choose a custom page size when you click on empty space on page and then then have a wider page

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 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.

October NL Carousel

Fabric Community Update - October 2024

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