How to hide and fix the column width

[Anonymous]

I'm a beginner.
Currently being created Matrix is ​​being created. I have a column that has only some whitespace and I want to hide it.

I was able to turn off word wrap, turn off auto-adjusting column widths, and move column widths to temporarily hide them.

However, when I update the data, it comes out again.

Is there a way to set the column width of the column to 0 and fix it even after the data is updated?

By the way, the connection method is a direct query.

Thank you in advance

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

It’s my pleasure to answer for you.

According to your description,I think you can try to turn off ‘show items with no data’ option in matrix.

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

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

[amitchandak]

@Anonymous , You can change it manually like excel. Go to the edge of the column in hear. You will get resize mouse pointer. Then you can resize.