Skip to main content

Power BI

Needs Votes

Hide/Show Column on Table

Vote (714) Share
's profile image

on 22 Aug 2017 15:55:59

Column visibility , depends on the criteria there should be an option to show/hide column on table.

Comments (60)
's profile image Profile Picture

Frank on 05 Jul 2020 23:30:20

RE: Hide/Show Column on Table

We use id columns in Direct Query mode to drill through to another page.
These id columns have to added value to the user so we want to hide them.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:27:31

RE: Hide/Show Column on Table

This seems like something that would be extremely useful....as would easily being able to reorder rows instead of using some complicated workaround.

's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:21:35

RE: Hide/Show Column on Table

I am able to reduce the width of the column to a negligible size (but still noticeable with an exacting hover), but am unable to truly hide the column - is there a way to do this? Additionally I agree that, upon export, the hidden column should not be returned in the result set. Our clients have no interest in seeing our key values!

's profile image Profile Picture

Nishanth V on 05 Jul 2020 23:20:31

RE: Hide/Show Column on Table

'@jeyakumar - Can you please help us how are you able to hid the column in a table.

's profile image Profile Picture

Jeyakumar on 05 Jul 2020 23:19:54

RE: Hide/Show Column on Table

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.

Thanks in advance.

's profile image Profile Picture

Jeyakumar on 05 Jul 2020 23:19:54

RE: Hide/Show Column on Table

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.

's profile image Profile Picture

Miguel on 05 Jul 2020 23:19:17

RE: Hide/Show Column on Table

Hiding columns on conditions is a must...

's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:19:12

RE: Hide/Show Column on Table

Additional functionality here, if you hide a column in the report, it should not be visible if the data is exported to a CSV or Excel sheet.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:18:52

RE: Hide/Show Column on Table

This will help so much with reports

's profile image Profile Picture

Mark on 05 Jul 2020 23:04:03

RE: Hide/Show Column on Table

This makes sense. Ideally we can utilize columns for data grouping and sorting but not actually have to display them on the report.

Merged Idea (1)