cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

Hide Columns in Dataset

Is there a way to hide columns in a data set?  I have a large dataset table that currently only need to use some of the columns and therefore would be nice to hide the unwanted columns to reduce the visual dataset table size.  I am aware I can delte columns, but I may want to use these columns in the furture and therefore hiding columns is a tidier approach.

2 ACCEPTED SOLUTIONS
Super User IV
Super User IV

@StuartSmith , If you do not need at all then remove in edit query/data transformation mode.

Else right click on the column name and Hide in Data/Visual Tab



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Frequent Visitor

You can remove columns from dataset in two ways:

1. Go to transform tab and right click on column name and click remove column option or you can do ctrl + click  on different to remove multiple columns.
2. If you dont want to remove them come back to main power bi window and go to Modeling Tab. Right click on a column and select Hide in Report view. Now the column will no longer be visible on visualization tab.

View solution in original post

3 REPLIES 3
Super User II
Super User II

@StuartSmith 

 

Another way to "hide" columns, besides the methods already suggested, is to select the columns you want Power Query to load into the model. If you need these in the future, you can just go into Power Query and re-select the columns you left out originally:

 

Choose Columns.JPG

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Frequent Visitor

You can remove columns from dataset in two ways:

1. Go to transform tab and right click on column name and click remove column option or you can do ctrl + click  on different to remove multiple columns.
2. If you dont want to remove them come back to main power bi window and go to Modeling Tab. Right click on a column and select Hide in Report view. Now the column will no longer be visible on visualization tab.

View solution in original post

Super User IV
Super User IV

@StuartSmith , If you do not need at all then remove in edit query/data transformation mode.

Else right click on the column name and Hide in Data/Visual Tab



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors