Slicer for both ROWS and COLUMNS

[Anonymous]

Hi folks,

I am working on a product comparison table where I lay out features of several instruments. 

It looks like this :

Category	Sub-Category	Feature	Instrument 1	Instrument 2	Instrument 3
Hardware	Display	Size	Large	Medium	Small
Hardware	Display	Touch-Screen	No	Yes	Yes
Associated Reagents	Loading on instrument	Max loading capacity	100 tubes	150 tubes	200 tubes
Associated Reagents	loading on instrument	tool required for loading	Yes, tube handler	No	No

So I would like to add slicers on the following elements

• Category
• Sub-Category
• Feature
• Instrument

The idea would be that our sales people can choose

1. What features they want to compare
2. On which instrument they want to perform a comparison.

The result would look like the following :

Category	Sub-Category	Feature	Instrument 2	Instrument 3
Hardware	Display	Touch-Screen	Yes	Yes

I tried with unpivot but haven't been able to make it work, especially since I want slicer to go in both ROW and COLUMN direction. 

But maybe I didn't look at it deep enough? Anyway, your help is highly appreciated. 

Thanks in advance. 

Best, 

Thomas

[MFelix · Accepted solution]

Hi @Anonymous 

On Power query you need to select the 3 instruments and then unpivot now set up a matrix in the following  way:

• Rows:
  • Category
  • Sub-Category
  • Feature
• Columns
  • Instrument
• Values
  • Values

then setup your slicers.

Check PBIX file attach.

[Anonymous]

Hi @MFelix,

Thanks for your quick response, that is exactly what I needed. 

Thanks for the file too, really helps understanding. 

Best, 

Thomas