dependent filters for power pivot tables

orange12345

New Member
Joined
Jan 25, 2016
Messages
40
Office Version
  1. 365
Platform
  1. Windows
Hi there, hope all is doing good.
I created a pivot table where the data comes from the data model in power pivot.

In this pivot table, I put three filters so the users could select the team, the person and then a date.

I'm trying to figure out a way to make these three filters dependent, for example: if the users select team A first, then under the person filter list, it will only show the person names in team A. Slicers will be a good way, however, the client wants to have a drop-down list for the table.

I'm struggling to achieve this. For now, I have around 100 people overall, so whenever the user selects the team, they still have to go through the second filter and find the name of the person which is a pain. I appreciate all your help and thanks in advance.
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,819
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Pivot table filters do not work that way, I'm afraid. Slicers are the simplest option unless your lists are fairly static.
 

orange12345

New Member
Joined
Jan 25, 2016
Messages
40
Office Version
  1. 365
Platform
  1. Windows
Pivot table filters do not work that way, I'm afraid. Slicers are the simplest option unless your lists are fairly static.
Hi Rory, thanks. Yeah I think slicer is good, but trying to find a way to make slicers look like a drop down list as per client request. Thanks for your quick response though.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,754
Messages
5,574,038
Members
412,565
Latest member
roberttaekim
Top