Easy Tech TutsHow to Hide a Column in a Power BI Table Visual Easily 2026
By Impran M N
Streamlining a corporate dashboard sometimes means hiding a redundant relationship key or helper column without actually removing it from your visual well or breaking underlying DAX measures. Power BI's visual formatting panel lets you collapse a specific column's width down to zero, keeping the data available while hiding it from view.
01Select your table or matrix visual
Click the visual containing the column you want to hide to bring up its formatting options.
02Open the visual formatting panel
Navigate to the upgraded formatting container to access individual column-level formatting rules.
03Turn off Auto-size width
Disable the auto-size width lock for the specific column so you can manually control its dimensions.
04Collapse the column to zero
Manually set the column's width down to zero pixels, effectively hiding it from view while keeping it in the visual well.
05Confirm sorting and tooltips still work
Check that the hidden column still supports sorting or tooltip functions if that was the reason you kept it in the visual well.
Frequently asked questions
Does hiding a column remove it from my data model?
No, collapsing a column's width in the visual only hides it from view; the field remains in the visual well and data model.
Can a hidden column still be used for sorting?
Yes, keeping a column in the visual well while hiding its width lets it continue to support sorting or tooltip functionality.
Why should I hide a column instead of removing it?
Hiding avoids breaking dependent DAX measures or table structure that might rely on the column still being present in the visual.
Is there a simpler way to hide a column than adjusting width?
Adjusting width to zero via the formatting panel is the standard method, since table and matrix visuals don't have a dedicated one-click hide toggle for columns.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
