Looking for a way that slicer shows only the selected columns

[aameri]

Hi, I am new to Power Bi. I have a main table with more than 100 columns.
I am trying to visualize a table with columns based on a slicer.
I have created a new table with the name of all the columns and have built a slicer based on it. I want the table on the dashboard to only show the columns I have selected. Currently, the slicer is not working as it is built upon another table. 
Can anyone help me with it?

[CerebusBI · Accepted solution]

Welcome @aameri!

Let's assume we have "employees" who each have multiple attributes. So in your example "AutoCat.Aii schedules" = "B. Need Guidance" etc.

In this case, I would proceed as follows:

Data model: make sure that the table is unpivoted in the data model.

I.e. for each employee there is a row for each "attribute/value" pair like this:

Visual: Use a matrix visual instead of a table visual:

• Row: column "Employee" of the table
• Column: column "Attribute" column of the table
• Value: (Implicit or explicit) Measure with reference to column "Value" of the table.

Slicer (or filter): "Attribute" column of the table

Does it work as desired?

[Tanushree_Kapse]

Hi @aameri ,

First of all, make sure that the field you are using in your slicer is from the new table only...(the table whose column you want to slice using slicer).

Or else:

check the relationships and cardinality between the two table- The main table and the new table created.

Mark this as a solution, if I answered your question. Kudos are always appreciated.

Thanks