Forum Discussion

JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
4 hours ago

How to decrease height of row (with image) in matrix?

Hi 

I have my PBIX file here.

I am trying to decrease the height of row in this matrix?

 

It is due to the image (red stop image), but I am not sure how to go about decreasing it.

The image itself is not that big, and I was expecting that, somehow, matrix would wrap to its size, but it didn't.

Without image, bottom is what I had originally.

Appreciate for help!

 

Need Help

3 Replies

  • maruthisp's avatar
    maruthisp
    Icon for Super User rankSuper User
    4 hours ago

    Hi JustinDoh1​,

    Check the attached file with changes.

    Can you try below format options:

    Try reducing both the image size and the row padding. Select the Matrix:
    Format visual - Visual - Image size
    Reduce: Height = 12 or 16 Width = 12 or 16

    Then go to:
    Format visual - Grid - Options - Row padding and reduce the row padding to something like 0

    Also check: Format visual - Values - Text wrap and turn it Off if you don't need wrapped text, because wrapped values can also increase the row height.

    Best Regards,
    Maruthi
    LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/
    X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

    • JustinDoh1's avatar
      JustinDoh1
      Icon for Post Prodigy rankPost Prodigy
      15 minutes ago

      maruthisp​ Thank you so much for your help.

      I am having an issue opening your attached PBIX file.

      First it indicated that I need to enable PBIR Preview, so I did on my Power BI desktop setting.

      Now, it indicates this:

      Can you please help me what needs to be done or attach other PBIX file (if it does not require this issue to be taken care)?

      Thank you.

  • Shai_Karmani's avatar
    Shai_Karmani
    Icon for Super User rankSuper User
    4 hours ago

    The matrix auto-sizes each row to fit the tallest cell content, so the image itself is what is stretching the row. To shrink the row you have to shrink the image inside it.

     

    Open the Format visual pane on the matrix, expand Cell elements, change the "Apply settings to" dropdown to your image column, turn Image size on, and set Height and Width in pixels. Bring those values down until the row looks the way you want.

     

    Also confirm the field feeding the image is set to Data category = Image URL under the Column tools tab, otherwise the Image size options will not appear.

     

    If this helped, a thumbs up and marking it as the accepted solution would be appreciated.

     

    Thanks,

    Shai Karmani