static matrix size
1 Topic
Matrix Page Scaling/Setting Static Matrix Width in Power BI Report Builder
I need to create a table that can vary widely in its rows and columns, depending on our customer. A table might be anywhere from 2 to 20 rows/columns and a customer could have 1+ tables, and it needs to be printable to PDF. I usually work with Power BI, but since there were a lot of dynamic parts to this report, it sounded like Report Builder was the way to go. I’ve been working with Report Builder for a bit now, but I’m running into an issue where my Matrix’s columns in Report Builder are overflowing to another page when there are too many columns, making the printable report look very messy. Is there something I can do to fix this? I can only make the font so small, and on tables that don’t have a lot of columns, having such a small font looks silly. I was hoping for something like scaling the matrix to fit to a page or setting a fixed max width, but I haven’t run into any useful info. I’m only worried about keeping all the columns on one page, not the rows.Solved829Views0likes3Comments