Easy Tech TutsHow to Hide Columns in Power BI (Cleaner Data Model) Easily 2026
By Impran M N
A data model stuffed with every raw column makes report building slower and confuses anyone browsing the field list. This guide covers how to hide unnecessary columns in Power BI so your model stays focused on what matters. It's a quick, practical skill for anyone maintaining reports used by more than just themselves.
01Understand why you'd hide columns
Hidden columns reduce clutter in the field list and prevent report users from accidentally dragging in raw, unformatted, or irrelevant fields.
02Hide columns step by step
In the model view or fields pane, right-click the column you want to hide and select the option to hide it from report view.
03Apply this to real use cases
Hide fields like internal IDs, helper columns, or duplicate calculations that support your measures but shouldn't be visible to end users.
04Follow best practices for data presentation
Keep a naming convention or documentation of hidden columns so other report builders on your team know what's available but tucked away.
Frequently asked questions
Does hiding a column delete the data in Power BI?
No, hiding a column only removes it from the visible field list for report building — the data stays in the model and can still be used in measures.
Can hidden columns still be used in DAX formulas?
Yes, hidden columns remain fully accessible in DAX expressions and calculated measures, they're just not shown in the fields pane for drag-and-drop use.
How do I unhide a column later?
Right-click the hidden field in the model view and select the option to show it again, which restores it to the visible fields pane.
Should I hide columns before or after building my report?
It's generally easier to hide unnecessary columns early, once you know which fields support your measures versus which ones report users actually need.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
