Forum Discussion

Rnaval's avatar
Rnaval
Post Partisan
1 year ago
Solved

How do I limit column width and row height in a Matrix Visual?

How do I limit column width and adjust row height for specific columns in a Matrix Visual?

  • Thankyou, Arash_Bhz, for your response.

    Hi Rnaval,

    We appreciate your inquiry through the Microsoft Fabric Community Forum.

    As per my understanding, in Power BI's Matrix visual, it is not possible to set column width or row height dynamically. However, you can control them as follows:

    1. To limit column width, go to the Column headers section in the Format pane, turn off "Auto-size column width," and then manually resize each column by dragging.
    2. To adjust row height, go to Grid → Row padding, where you can increase or decrease the row height uniformly for all rows.

    Currently, Power BI does not support adjusting row height for specific columns or rows. Kindly consider the following alternatives:

    1. Enable text wrapping for better visibility of content.
    2. Use separate visuals like Tables or Cards for more precise layout control.
    3. Leverage Tooltip pages for dynamic and detailed views without changing row heights.

    If you find our response helpful, please mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.
    Should you have any further questions, please feel free to contact the Microsoft Fabric Community.

    Thank you.

5 Replies

  • Arash_Bhz's avatar
    Arash_Bhz
    Frequent Visitor

    You can not set a specific row or column width and height, you have to adjust and drag them manually, unfortunately.
    In the visual format pane:
    For Columns:

    • Go to Column headers → Turn "Auto-size column width" → Off

    • Now manually resize columns and they will stay as set.

    For rows:

    • Grid → Row padding: Increase or decrease padding to control row height.

    • This affects all rows uniformly, not individual ones.

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support

    Thankyou, Arash_Bhz, for your response.

    Hi Rnaval,

    We appreciate your inquiry through the Microsoft Fabric Community Forum.

    As per my understanding, in Power BI's Matrix visual, it is not possible to set column width or row height dynamically. However, you can control them as follows:

    1. To limit column width, go to the Column headers section in the Format pane, turn off "Auto-size column width," and then manually resize each column by dragging.
    2. To adjust row height, go to Grid → Row padding, where you can increase or decrease the row height uniformly for all rows.

    Currently, Power BI does not support adjusting row height for specific columns or rows. Kindly consider the following alternatives:

    1. Enable text wrapping for better visibility of content.
    2. Use separate visuals like Tables or Cards for more precise layout control.
    3. Leverage Tooltip pages for dynamic and detailed views without changing row heights.

    If you find our response helpful, please mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.
    Should you have any further questions, please feel free to contact the Microsoft Fabric Community.

    Thank you.

    • Rnaval's avatar
      Rnaval
      Post Partisan

      I'm not seeing those options under the Format menu...

       

       

  • Hi Rnaval ,
    In Power BI, it is not possible to dynamically adjust column widths or row heights in the matrix visual. To control a specific column’s width, you need to manually resize it by dragging its header border, then turn off the “Auto-size column width” option under “Column headers” in the Format pane. For row height, you can enable or disable “Word wrap” in the “Values” or “Row headers” sections to affect row height, but there’s no way to set exact row height values.