Hello all,



I would like to know if it is possible to create a master slicer(or filter) from a range of slicers created from pivot table.

I have created a trend chart of revenue based on 4 different metrics such as Direction(Inbound,Outbound), Payor(Local,Offshore), Segment(SME, Large, Global) and Weight(Heavy,Medium,Light). Currently I can filter based on any of the 4 metrics, But I am unable to look at the trend for 1 specific slicer.

For example, I cant see the trend just for Direction. Thus the idea of inserting a master slicer for the 4 metrics. Is this achievable? Or am I missing a simpler solution?

Thanks!

Without example workbook I'm not sure what exactly you want to do. Do you want to display on graph data from any of source table columns used as filter condition? Then add into source table additional (hidden) column(s) with cells linked to data in filter condition columns. In pivot table use added columns in Data section.

Ive attached a sample file for your reference.

On the Dashboard sheet, I connected the Line chart to 4 slicers. But is it possible to have 1 master slicer to only see the figures of Segment, for example.

In other words, I would like to deselect all other 3 slicers when I select Segment.

Attached Files

Sample.xlsx (30.8 KB, 11 views)

Do you mean, that on sheet Pivot, you can select All for PAYOR, DIRECTION and WEIGHT_TYPE, and set a filter for SEGMENT to specific one - and on sheet Dashboard you can't?

Select all choices in group one-after-one holding Ctrl key down!

Hmmmm, I guess I am complicating things here. Probably the only way around is to select all other 3 slicers, and select the specific category in Segment, if I want to see the figures for Segment.

I know it doesn't make sense to you or seem confusing. That's because I sort of confused myself as well. Hahahaha.

Thanks for your time anyway!