Slicer

Hello,

You won't be able to simply drag the fields into a slicer to have them be selectable. What I would do is create a table in your model that lists your product types. Go to your Relationships view in your model file. On the Home tab, click Enter Data (in External Data section). then manually input the product types you want in your slicer. You can name your column "Product Types". Click Load, this will create your table. You'll also need to link it up to the main table that'll have these product types. After creating the relationship, you will be able to drag this column into a slicer. It'd look something like this:

jhaldane as AlexisOlson mention, unpivot your data and then set the relationship between two tables.

Unpivot is easy, selected first two columns and then choose "unpivot other columns", you will get two columns "Attribute" and "Value", rename those columns whatever you want and go from there.