matrix formatting: setting width of the column and height of the row

[Anonymous]

Hi,
I have a matrix like this:

I use conditional formatting to color the background and font - I don't want to see the values - I'm only intrested in the color (if the value > 100, color is blue - otherwise is green).

What I need to change here is to make the cells smaller: I would like to set the width and height to e.g. 10 pixels. I dindn't find this possibility on the format tab of the matrix.

Do you know any way to achieve this? Or maybe there is other visual, similar to matrix that would allow me to set the size of the cell?

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

For the height of the row, 

You can do it from VISUALIZATIONS>>FORMAT>>GRID>>ROWPADDING

Please see the pic below

and for the width of the column,

Turn on word wrap in column headers and adjust width with mouse by dragging the column width.

Best Regards,

Lin