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)
- Merged Idea (1)
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.
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!
RE: Hide/Show Column on Table
This says it needs votes, but won't let me vote on it. Way to go, Microsoft.
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
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
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.
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.
RE: Hide/Show Column on Table
'+1
RE: Hide/Show Column on Table
We have quite a few users that want columns hidden from visuals, but displayed in the summarized export in Excel. This feature would help greatly in that aspect.
RE: Hide/Show Column on Table
Please also add option to hide valuecolumns for columns but not for total.
For example: I have a Actual vs Budget Matrix. I want to show Actuals on Weekly basis (Dates[Year-Week] in Columns) and compare the total for the month with Budget on Month basis. Currently it adds a Budget valuecolumn for every week in the Matrix. What I want is a Margin shown for every week, followed by Total Margin followed by Budget and then Delta Actual vs Budget. So from left to right; Week-Margin, Week-Margin, Week-Margin, Week-Margin, Total-Margin, Total-Budget, Actual-vs-Budget.
I tried generating blank values with HASONEVALUE and then disable wordwrap and manually hide the columns, but when a different month is chosen they pop back up again.
A menu option that gives control for each Value to show on columns, columns and totals or totals only would be perfect!