Hiding certain columns in matrix visual

[Quentidus]

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.

[LukeAutumn]

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.

[Ritaf1983 · Accepted solution]

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

[Quentidus]

Thank you for the quick response @Ritaf1983  🙂

Yes, the second column is just for totals. I will try out the links you've posted! Thank you!