Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
@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
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.
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:
Proud to be a Super User!
Paul on Linkedin.
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.
@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