Forum Discussion
Hiding certain columns in matrix visual
Hi. Does anyone have a solution to hide certain columns in a matrix visual? Earlier posts do not seem to solve my problem. Simply hiding the columns by dragging them is not an option, since my real data has too many of such columns.
As an example I want to hide only "Software Costs" as in the picture below, and only display "FTE Values". Any help will be greatly appreciated, thank you.
Hi Quentidus
There is no option to hide a column in the matrix visual.
If the second column here is just for "totals"You can create a matrix with multiple-column totals with calculated groups instead of using unnecessary columns.
Please refer to the linked video guide:https://www.youtube.com/watch?v=ExCD0vM-OEU
Or with disconnected table and dynamic measure , the guide for this method is :https://www.youtube.com/watch?v=DIc-KFPr4LI
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
- Ritaf1983
Super User
Hi Quentidus
There is no option to hide a column in the matrix visual.
If the second column here is just for "totals"You can create a matrix with multiple-column totals with calculated groups instead of using unnecessary columns.
Please refer to the linked video guide:https://www.youtube.com/watch?v=ExCD0vM-OEU
Or with disconnected table and dynamic measure , the guide for this method is :https://www.youtube.com/watch?v=DIc-KFPr4LI
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Just right click the column(s) and hit "exclude".
The excluded columns will then appear in the filters pane so you can always delete the filter/add them back in if you want.
