Eliminate fields from a table using a SLICER

[rtu_tw]

I would like to add a slicer to be able to eliminate some of the Fields in a Table. For example, one of my table's columns is 'Fan on/off'. When I create a slicer for this field, it only allows me to select when the Fan is on or off. I would like to be able to turn this field off completely so that 'Fan on/off' disappears from the table. Yet the user can quickly turn it back on again.

The reason is that my table has over 20 columns. I am looking to enable the user to select just the fields they way to look at and the table just shows those columns. 

[CheenuSing]

Hi @rtu_tw

Follow the link

http://breaking-bi.blogspot.in/2016/06/power-bipowerpivot-using-slicers-to.html

This is to choose the values you want to display, the reverse of your request.

Cheers

CheenuSing