Forum Discussion
How to hide and fix the column width
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
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.
2 Replies
- amitchandakSuper User
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.
- v-janeyg-msftCommunity Support
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.