Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

  • 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-msft's avatar
    v-janeyg-msft
    Community 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.