Slicer help

[Noxqss38242]

Is there a way to have the slicer select the info horizontally?

I have trailer group numbers:

Groups Body Rear Brakes Electrical
185385 - 185584 700 300 900 500
633753 - 633812 350 900 200 1000
ETC...

Can I put in a slicer to select groups as well as the titles IE: Body, Rear, Brakes, Electical?
So one slicer is vertical info of selecting the groups and another slicer to select the item listed at the top of each column?

 

[sandy666]

is that what you want?

btw. update your profile about Excel version, please

 

[Noxqss38242]

Excel 2016

I believe that is what I want.

 

[sandy666]

Excel 2016

I believe that is what I want.

yes, but do that in your profile not in the post

anyway, post#2 is what you want?

 

[Noxqss38242]

Profile updated for that.

Yeah, I want to select a trailer range/ranges, then I want to select the area of issue "Brakes, Lights, Rear, etc..." eventually seeing on a pivot graph what each group of trailer is costing per "area" using the various slicers. Right now, boss just has them conditional highlighted and I think it looks like it can use some visual updating.

 

[sandy666]

Profile updated for that

Great

but you didn't answer in post#2 is that what you want? Yes or No

 

[Noxqss38242]

Yes

 

[Noxqss38242]

is that what you want?
View attachment 20072

btw. update your profile about Excel version, please

Yes

 

[sandy666]

ok, here is file with your example

s666-PQ-PT-slicers.xlsx

Microsoft Excel Workbook

1drv.ms

- load table into PQ editor
- unpivot other columns except groups
- close&Load as connection
---
in the worksheet
- Insert Pivot Table
- use an external data source
- choose your Query table
- add group and value to the ROWS
- create slicers

 

[Noxqss38242]

Yes, that is exactly what I need. How do I do that?