Hide matrix columns without unwrapping headers and dragging to minimise

[_101_]

Hi there

Is there a way that I can hide some columns in a matrix. The solution of unwrapping text and minimising column widths is not ideal as the end-user can widen the columns and also export the data in these columns, but in my case the data in these columns are meaningless and I don't want the end user misinterpreting it.

My table is somewhat like this and I want the colums with the red cross through to be hidden.

Alternatively, if unwrapping and minimising widths is the only option, is there a way to lock the tables so the end user can't widen the columns, and export the "hidden" columns?

Many thanks from a new PowerBI user

[Ritaf1983 · Accepted solution]

Hi @_101_ 

Unfortunately, there is no option to hide columns.

There are some ideas on this subject, you can vote for them here :
https://ideas.fabric.microsoft.com/ideas/search-ideas/?q=hide%20columns%20in%20matrix&forum=2d80fd4a...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly