How can I create slicers of "views" of my data?

[cr731]

Is it possible to create slicers for different "views" of data - meaning that a single slicer will control multiple filters?

I have different teams and want to prepare a single report and have a slicer to let them filter for the data relevant to them. The problem is that it isn't a single column with values for each team that I can easily create a slicer off of. It's a combination of different fields and values.

Currently, I have to create multiple tabs for each team with different filters in the pivot table... and it would be much preferred to simplify it into one.

I'm open to any solution involving Power Query/Pivot/View.

Thanks

 

[esadovnic]

Sounds to me like you might want to play with the Perspectives feature under the Advanced tab. Not sure that might be the right feature for what you're trying to accomplish, which brings up a few more options. Links: since it's troublesome to make new sheets over and over with the same layout, just Copy one existing sheet without filter and name them per group/user. In this scenario you can have a small landing page with the relevant party names hyperlinked with the corresponding tabs to take them to "their" view.

Maybe this isn't feasible, but you can also opt into an elaborate SWITCH() that harvests your selection per user if you can somehow delineate which data is pertinent to which user, then based on that slicer selection (Disconnected Slicer/Table technique) bring in the relevant measures and filters.

Hope this helps!

 

[elliotstan]

I think this is an example of what esadovnic is talking about

Not sure if its the exact thing you are after but might help.
What are Pivot Table Report Filters and How to use them? | Chandoo.org - Learn Microsoft Excel Online
Update Report Filters using simple macro – a Dynamic Pivot Chart Example | Chandoo.org - Learn Microsoft Excel Online