Can we hide column in table visual ?

[admin_xlsior]

Hi all,

As subjected, can I have, while a rank column is added in the table, but I want it to be hidden? reason is this column is a measure which "act" as row order. There is not much space, and not really matter to show it, but it did very important I want other column (field) still show, but the ordering will need to be based on that rank measure.

Thanks.

[MFelix · Accepted solution]

Hi @admin_xlsior,

You can shorten the wide of the column until you don see it anymore, be aware that you may need to turn off word wrap:

This works for table visualizations and matrix.

Be aware that hiding this column if the users click on another column the table will be order by that selection, then they need to reset the to default to see it again by the order of that measure.

[WojciechPolak]

This question is quite old, but in 2023 you can avoid turning off word wrap for column headers by giving column that you want to make invisible one letter long name. It's important to track if the word wrap for values is not necessary though.

[mahoneypat · Accepted solution]

If you rank values are in a calculated column, you could use that column as the Sort By Column for the column you want to show.  If it is a measure, I don't think you can sort my a measure that isn't in the visual.  However, you could add it, put it at the end (out of scroll window) and/or play with the font/background colors and/or column widths to hide it.

Regards,

Pat

[MFelix · Accepted solution]

Hi @admin_xlsior,

You can shorten the wide of the column until you don see it anymore, be aware that you may need to turn off word wrap:

This works for table visualizations and matrix.

Be aware that hiding this column if the users click on another column the table will be order by that selection, then they need to reset the to default to see it again by the order of that measure.

[Anonymous]

I did this for a count column that I had. For whatever reason, I couldn't get my report to show all assets regardless of cost even if I set cost as >=0 without adding a count of assets. However, I don't want to show that count. Thankfully, I found this post. I didn't turn off word wrap. I simply titled the column "1", squeezed it down, and moved it to be the last column. I only moved it because when I viewed the report in the app, I noticed that if your mouse just barely hovers the dividing line between the first (hidden) and second columns, it gave the user the ability to increase the size of the hidden column. Most people aren't likely to hover a mouse past the last column so it's a little safer there. I really wish Microsoft would give us this as an ability to hide columns neatly rather than this "hack" approach. 

[Anonymous]

Love it!