Skip to main content
Microsoft Idea

Power BI

Needs Votes

Hide/Show Column on Table

Vote (694) 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 (62)
's profile image Profile Picture

Tony Dennis on 24 Feb 2021 23:39:06

RE: Hide/Show Column on Table

I'm new to this Power BI, however, a lot of experience in other visualisation tools. I cannot believe that this is not a standard function

's profile image Profile Picture

Rob Jarrett on 30 Jan 2021 03:21:08

RE: Hide/Show Column on Table

There are drill through situations where the column used to link is not something you want to be displayed (or exported) in the data grid. For example, say we have a SITE and ITEM two column filter. To make the relationship linkage we concatenate SITE&ITEM into a SITE_ITEM column in the parent and child tables.

We then add SITE_ITEM to the drill through filters and to the table grid on the parent report. We want to show SITE and ITEM as two columns in the parent table grid, not the concatenated link that is used by the relationship to drill through.

We need to be able to add SITE_ITEM to the parent table grid, hide it and use it as the link to the child drill through.

's profile image Profile Picture

Jhinge Pranav on 09 Jan 2021 07:03:00

RE: Hide/Show Column on Table

As a user and developer I am amazed this does not exist yet, and has so little votes, this is a no brainer, basic stuff, this could actually stop Qlik users who plan to migrate to PowerBI from doing so.

's profile image Profile Picture

Geraldine Cros on 02 Dec 2020 16:18:42

RE: Hide/Show Column on Table

Please add this option asap!
It can be critical to be able to hide some columns (with confidential information) in a table and lock it. That means that, when a column is hidden and the table locked, the hidden column doesn't show when the user exports it to Excel for example.
Thanks!

's profile image Profile Picture

Kris Tyler on 11 Nov 2020 13:59:20

RE: Hide/Show Column on Table

This says it needs votes, but won't let me vote on it. Way to go, Microsoft.

's profile image Profile Picture

Daniel Rider on 16 Oct 2020 14:51:08

RE: Hide/Show Column on Table

Add this to conditional formatting for both the matrix and table. This should be a no brainer item to add. Both Qlik and Tableau allow this.

@Microsoft - Don't skip the basics

's profile image Profile Picture

Michael Hammons on 14 Sep 2020 20:20:54

RE: Hide/Show Column on Table

Need ability to allow end user selection of columns from a slicer visual that adds/removes columns from a table/matrix/bar/column visual.

Slicer with field/columns names Table visual
x A Category A B D E
x B
□ C
x D
x E

's profile image Profile Picture

Karen Lillystone on 18 Aug 2020 11:12:28

RE: Hide/Show Column on Table

Have this ability in SSRS to hide conditionally - rows / fields.

Need this ability in power bi. Unable to vote on this however.

's profile image Profile Picture

Siva on 10 Jul 2020 17:21:35

RE: Hide/Show Column on Table

This would be an excellent feature if it's considered.
With the help of this feature, we can provide dynamic columns selection to end-users.

's profile image Profile Picture

Power BI User on 06 Jul 2020 00:17:48

RE: Hide/Show Column on Table

'+1

Merged Idea (1)