cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Slicer for both ROWS and COLUMNS

Hi folks,

 

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

It looks like this :

 

CategorySub-CategoryFeatureInstrument 1 Instrument 2Instrument 3
HardwareDisplaySizeLargeMediumSmall
HardwareDisplayTouch-ScreenNoYesYes
Associated ReagentsLoading on instrumentMax loading capacity100 tubes150 tubes

200 tubes

Associated Reagentsloading on instrumenttool required for loadingYes, tube handlerNo

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-CategoryFeatureInstrument 2Instrument 3
HardwareDisplayTouch-ScreenYesYes

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Slicer for both ROWS and COLUMNS

Hi @ThomasGuyon 

 

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: Slicer for both ROWS and COLUMNS

Hi @ThomasGuyon 

 

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





View solution in original post

Highlighted
New Member

Re: Slicer for both ROWS and COLUMNS

Hi @MFelix,

 

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

Thanks for the file too, really helps understanding. 

 

Best, 

 

Thomas

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Kudoed Authors