How to show/hide data column in power bi Table report view

[lalit2207]

How to show/hide data column in power bi Table report view

I have 10 column in a table , Now i build a table report with 5 fields , how  should i allow user to add another 5 field in report view  or remove any field  as per user requirement

[v-chuncz-msft · Accepted solution]

@lalit2207,

You may select Unpivot Columns in Query Editor, then use a Matrix visual to display the data. That way, you may take advantage of Visual level filters.