How to adjust the matrix width and height in order to fulfill the box

[Anonymous]

Hi all,

I was trying to make a matrix to fulfill the whole box. I tried several ways mentioned online. However, it did not work out. Coula you plesae help me with this issue? thanks in advance!

[v-yanjiang-msft]

Hi @Anonymous ,

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ kalyj

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

In the visual formatting pane>Grid>Options, there are two option, Row padding and Global font size, you can set it there.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[danextian]

Hi @Anonymous ,

You can extend the column width and not set to the column header width to automatic. As to the height, it will be filled only as necessary. Alternatively, you can can a background color to your matrix visual but that will only fill the box with a color.

[Anonymous]

Hi @danextian ,

Thanks for your reply. I turned off the Auto-size width under column header section. It seems there is no change on my table. Could you please help to provide more help with the table width adjustment? I basically want to fulfill the table in the whole botten page. Should I consider chnage the font size?

Thanks in advance!

[danextian]

When you turn off the auto-resize of column width, the columns are stuck to the width they had prior to turning off auto-resize.  Auto-resize of column headers affects just the width and will not fill or unfill the black space after the last visible row in the table/matrix visual neither will it auto-resize the height of each row. You can add a background color to the visual to fill the blank space. Please refer to this link on how to do it - https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual