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)
- Merged Idea (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!
RE: Hide/Show Column on Table
Please add that feature.
Record containing table visual: date, client name, few other columns with details about this record and column containing notes for each record (logs, comments, snippets of code, etc - limited to 32k characters ...)
Default view:
notes column hidden - table contains about 15-20 records and no scroll needed,
option to show notes column - even single record requires scrolling now as notes column is long text, sometimes with paragraphs ...
RE: Hide/Show Column on Table
Need ability to add a button to a report to show/hide columns.
Example: An invoice report where we want ability to let user choose to show amounts with or without taxes included.
RE: Hide/Show Column on Table
Please include this option, this really help with creating needed visuals
RE: Hide/Show Column on Table
it would be helpful to still have the column in the visualization but be able to hide i
RE: Hide/Show Column on Table
'+1. Yes please! we need this
RE: Hide/Show Column on Table
The ability to hide or show a column using conditional logic (i.e. use a button to show/hide) would be great. These is available in other tools, such as Qlikview
RE: Hide/Show Column on Table
I need this every time i create a table as I have to show row labels in a certain order - they cannot be shown in alphabetical or numerical order. At the moment I am adding a sort column, hiding it from the report which doesn't hide it from the visual (which is the only way to get it to sort in the way I want). After that I am manually resizing the column width with word wrap turned off. Surely there has to be a better way.
RE: Hide/Show Column on Table
Hiding a column requires turning word wrap off but word wrap is usually needed. An easier option that doesn't compromise word wrap functionality should be available.