Hide Columns in Power BI | Power BI Tricks & Tutorials

This Power BI hide column tutorial shows teaches how to hide a column in Power BI lists. Power BI doesn't allow you to hide columns out-of-the-box, but this neat trick allows you to easily hide a column by manipulating headers and column width. It's a magic solution to a badly needed missing feature.

Check out our other Power BI tutorials in the channel playlist and let us know what topics you need covered.

Super Data Brothers is your one-stop shop for business intelligence and data analytics tutorials, news an opinion. We cover a wide variety of topics including Cognos Analytics and Power BI. Something you'd like to see? Let us know in the comments!

#powerbi #analytics #businessintellegence

[jkohlers]

Awesome. In PBI 2023 I was able to do this without having to rename the column. I just turned off the "text wrap" option for 'Values' and 'Columns Headers' and squeezed the column to the end, as you did.

[rodcris]

thanks for sharing! In case you wanted to hide the horizontal scrollbar too, you would want to move the hidden column to the middle of the table and adjust the table width again.

[lolitsajoke]

Thanks man! Saved me about 45min on my project for this client.
Appreciate it!

[inderrbajaj]

Or we can switch off wrap text option under column headers and then drag the column to 0 size... It will do that too...

[Mikel]

the best ones, are the simplest. Great workaround

Update:
This doesnt work in updated versions of Power BI. When I reduce size of the column the size of the rows expands, affecting how the table looks in general

Update to the update:

I moved the column (now first column of the table) and I aligned that specific column to the left. Now I could hide it and the rows didnt get distorted

[hhliu]

my column is a subcategory, the first category is Quarter3 and Quarter 4, how could I hide the subcategory for Q3 only, If I changed the column name, the Q4's subcategory name will be changed too which I don't want to change

[devacademy]

Hi but when you hover at extremely left side on any row you will see the values that time it's not good

[HectorPerez-lsfc]

In my case, I couldn´t change the name of the column because I wanted to hide only values for 2023 and keep 2024, I was showing YOY% and I don´t have values for 2022, so 2023 values were too big. I turned off text wrap for column header and values. It works fine. Thanks

[kamalgopalsingh]

What if want to hide columns for some filters ??? not for all ???
I created customer wise sales of selected year and previous year and growth, but for first year there is no data of previous then want to hide growth and last year data ??

please suggest me stuck in this since 2 days

[chrisnicey]

How do you hide/show the entire column based on a checkbox?

[Vaayamoodrakorangu_admin]

I need to hide empty columns based on the slicer selection! (There are 400 columns) SOlution in need of an hour

[TheTruthSpeaker]

Yeah I would never forget this trick. 😂

[yiyiwang]

how to only undo the text wrap on the column I want to hide?

[RohithN]

This is not working in the current version! But you can turn off the wrap text to work this.

[martinsolajide]

How do i hide a column for some users in PowerBI?

[dsswooshy]

The issue with this is it's still the first pivot column.

Not a true hide.