Forum Discussion
Post ProdigyHow 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!
Hi JustinDoh1,
The extra row height is coming from the image cell, not from the PNG itself.The native matrix does not auto-size rows to the actual image file. It uses a fixed Image size in the format pane (default is often around 75px). That value drives the whole row, including the star columns.
- Shrink the image size (this is the main fix)
- Select the matrix
- Format visual -> Visual
- Expand Image size
- Set Height and Width to something small, e.g. 20–24 px (range is 8–512)
That should pull the LB/MO rows back down close to the original star-only layout.
- Tighten the grid as well
Still on the matrix:
- Grid / Options -> reduce Row padding
- Values -> turn Word wrap off (wrap plus images makes rows even taller)
If you need compact rows and a small icon
If 20–24px still looks too tall, consider not using Image URL for a simple stop icon:
- A DAX/SVG measure with an explicit height/width (Recommended)
- Or a Unicode / conditional icon instead of a hosted image
Image URL is the least flexible option for row height.
Hope this helps! Please consider as an accepted solution if helps and give some kudos to help other community members.
6 Replies
- JustinDoh1
Lodha_Jaydeep Thank you!
- Lodha_Jaydeep
Solution Sage
Hi JustinDoh1,
The extra row height is coming from the image cell, not from the PNG itself.The native matrix does not auto-size rows to the actual image file. It uses a fixed Image size in the format pane (default is often around 75px). That value drives the whole row, including the star columns.
- Shrink the image size (this is the main fix)
- Select the matrix
- Format visual -> Visual
- Expand Image size
- Set Height and Width to something small, e.g. 20–24 px (range is 8–512)
That should pull the LB/MO rows back down close to the original star-only layout.
- Tighten the grid as well
Still on the matrix:
- Grid / Options -> reduce Row padding
- Values -> turn Word wrap off (wrap plus images makes rows even taller)
If you need compact rows and a small icon
If 20–24px still looks too tall, consider not using Image URL for a simple stop icon:
- A DAX/SVG measure with an explicit height/width (Recommended)
- Or a Unicode / conditional icon instead of a hosted image
Image URL is the least flexible option for row height.
Hope this helps! Please consider as an accepted solution if helps and give some kudos to help other community members.
- Shai_Karmani
Super User
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
- maruthisp
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 16Then 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
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.
- v-csrikanth
Community Support
Hi JustinDoh1
Try to install the latest version of PowerBI desktop and try to open the downloaded pbix file of maruthisp . If you still facing any issues let us know we are happy to assist you.Thank you.
