Forum Discussion

Crow_Pro's avatar
Crow_Pro
Regular Visitor
1 year ago
Solved

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.

  • Hi Crow_Pro Try setting dynamic column widths, enabling "CanShrink/CanGrow" for textboxes, and adjusting the page width in Report Properties. If the issue persists, consider exporting to Excel for handling wider matrices.

3 Replies

  • Hi Crow_Pro Try setting dynamic column widths, enabling "CanShrink/CanGrow" for textboxes, and adjusting the page width in Report Properties. If the issue persists, consider exporting to Excel for handling wider matrices.

    • Crow_Pro's avatar
      Crow_Pro
      Regular Visitor

      Thank you! I have looked into CanShrink/CanGrow, it has helped, but exporting to Excel might be the way I have to go.

  • v-achippa's avatar
    v-achippa
    Community Support

    Hi @IgorAM,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you Akash_Varuna for the prompt response.

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
    If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

     

    Thanks and regards,

    Anjan Kumar Chippa