cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ujeyakum
Regular Visitor

How to Hide a Column in power Bi

Hi All,

 

Can you please help me how to hide "Column A" in table but that column should be in order.

 

For example.

 

powerbi.JPG

Spoiler
 

 

Thanks,

Jeyakumar.

8 REPLIES 8
Super User III
Super User III

Re: How to Hide a Column in power Bi

Hi @ujeyakum,

 

On PBI if you rigth click the column name or table you can select the option Hide, this will hide the column from the visualization however you are abble to use it in your measures and calculations and is visible on the tables view in a grey format.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Check out my blog: Power BI em Português


Highlighted
v-piga-msft Resident Rockstar
Resident Rockstar

Re: How to Hide a Column in power Bi

Hi @ujeyakum,

 

You could adjust the column width manually. In your table visualization, hover your mouse over your column heading that you want to "hide" and move it to the right until the mouse cursor changes to a <-||->, then you could adjust the width of this column.

 

For the better visualization, you 'd better turn off the Word wrap in the format pane. The below should be your expected output.

 

Untitled.png

Hope it can help you!

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ujeyakum
Regular Visitor

Re: How to Hide a Column in power Bi

Hi Cherry,

 

Thanks for your reply.

 

I did the same but when you export the report it showing the column. How can i avoid that also.

 

Can you pls help me on this.

 

 

Thanks ,

Jeyakumar.

v-piga-msft Resident Rockstar
Resident Rockstar

Re: How to Hide a Column in power Bi

Hi @ujeyakum,

 

It seems that there is no options for us to achieve it in Power BI currently.

 

I suggest you could vote the ideas below which has been submitted in Power BI ideas forum and add your comments there to improve Power BI and make this feature coming sooner.

 

Hide/Show Column on Table

Allow Table and Matrix Data Exports to Match PowerBI Visual

 

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bajee Resolver III
Resolver III

Re: How to Hide a Column in power Bi

 

 hide.JPG

 

If you right click on column you will get options as screenshot.

 

select the hide option that particular column will be hide.If you want you can unhide the column

 

Regards,

Bajee.

 

ujeyakum
Regular Visitor

Re: How to Hide a Column in power Bi

Hi Bajee,

 

Thanks for your reply.

 

We are able to hide the column in a table, but when we export the data its showing with hidden column as well.

Can you please help me with this.

bajee Resolver III
Resolver III

Re: How to Hide a Column in power Bi

@ujeyakum

 

Yes, When you export the data from visual still we can able to see hided columns.

 

I don't thing so we can archive this.

 

Regards,

Bajee.

Super User III
Super User III

Re: How to Hide a Column in power Bi

Hi @ujeyakum,

 

What you want is to keep the Sr.No. in order?

 

If this is the point try to do the sort order choosing the column you want to sort the values by default. Not really sure if irt will work with your dataset since there isn't to much information.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Check out my blog: Power BI em Português


Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors