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

Herbert Majuba on 08 Dec 2021 11:00:24

RE: Hide/Show Column on Table

I needed to sort a table by calculated column but did not want to show the column because it took up space

's profile image Profile Picture

Christopher Wye on 23 Nov 2021 11:48:27

RE: Hide/Show Column on Table

I think the ability to hide a column in a visual is basic functionality, especially if you want to create dynamic measures to use the hidden column for filtering rows!

's profile image Profile Picture

Michael Doig on 12 Nov 2021 02:24:22

RE: Hide/Show Column on Table

We could do this with some conditional creativity in SSRS.

Building a drop down to give the user the ability to "show" the columns they want would be huge!

's profile image Profile Picture

Andreas Koblischke on 25 Sep 2021 13:25:12

RE: Hide/Show Column on Table

Needed: hide and show table columns managed by the end user.

Example:
* A multinational company with a business unit in each country.
* Every country does maintain the item numbers themselves.
* A worldwide item number format is mapped to the local ones
* Depending on the role the users needs Item and Description:
-> Worldwide only
-> Local only
-> Both

Without this feature we
* either give to much information for some users
* or we have to use bookmarks with a couple of duplicated visuals (Difficult to maintain)
* or we have to create a separated report for every user type (Ugly to maintain)

I totaly agree with Jhinge Pranav. A customer with the requirements above is currently using 200 Qlik licenses and asked us to showcase Power BI. Low brainers like this feature can be a game changer...

's profile image Profile Picture

Ann Weber on 25 Aug 2021 22:16:21

RE: Hide/Show Column on Table

The work around of making the font and the background white really doesn't work for a wide column.  I have values with the same title, but different ids.  I need to show multiple rows of titles where the ids are different and I need the measures to apply the current id, but the ids are ugly and no one wants to see them.  Having this feature would be perfect.  I hid columns all the time with SSRS.  It is even better if you can change the visibility of a column using an expression. 

's profile image Profile Picture

Mehdi HAMMADI on 18 Aug 2021 00:02:50

RE: Hide/Show Column on Table

This feature is most needed

's profile image Profile Picture

Steven Taub on 04 Aug 2021 14:05:10

RE: Hide/Show Column on Table

This would eliminate the need to create duplicate tables based on whether you need a field to be visible or not.

's profile image Profile Picture

Tom Power BI User on 14 Jun 2021 20:31:25

RE: Hide/Show Column on Table

Because drill-through filtering depends on data included in the source visual, we need to be able to include the column and hide it for that purpose.

's profile image Profile Picture

Satya Meka on 26 May 2021 09:13:47

RE: Hide/Show Column on Table

Very basic functionality available in all other BI tools, and very much critical for increasing user experience in adding self-service capabilities

's profile image Profile Picture

Yingke Tang on 26 Apr 2021 06:09:11

RE: Hide/Show Column on Table

Bookmark function in paginated version is heavily needed.

Merged Idea (1)