How to Connect Slicers on EXCEL Dashboards with Multiple Charts/Tables/Graphs

If you generate a dashboard with slicers in EXCEL that has multiple products (charts, tables, graphs) you must connect each product to each slicer in order for the slicers to filter the data in all the products together.

Just right click on each slicer and look under "Report Connections". It's almost self-explanatory what you need to do. If a box is unchecked that means the slicer is not connected to that product. If you want it to be connected, just check the box. Or, if for some reason you prefer to have slicers only interacting with certain products on your dashboard you can manually disable those connections.

[Etwenty]

helped me finish my assignment for class at 2AM
THANK YOU!

[JacobFolsom]

Thanks, this helped me out with getting started on slicers for a dash I'm putting together in Excel.

[xgalaxyone]

Thank you for your simple, short and clear guidance!

[Danny-Do-It]

So i have two pivot tables, and two line graphs, one slicer - when i click the Report Connections, I only see one table?

[teuteu]

I have a question why do i have to right click on the slicer to make it use?.

[golfpromal]

David, thank you for this information. I am an Excel veteran, self-taught. Working on a Mac with Excel 2016. Just very new to Slicers-first day. I am trying to create three different slicers all based on the same field in the source data called Month. One Slicer for Current Month, one for Trailing 3, one for YTD, and one for Trailing 12. Each of them would connect to their group of unique pivot tables. But what is happening when I do this is that the four slicers all end up showing the same selections within the slicer Dialog Box EVEN THOUGH they still only represent the choices originally selected. Very confusing. Any suggestions on how to have multiple slicers from the same source data field driving multiple Pivot Tables?

[tannertucker]

Thank you David. I have been using slicers for a long time. However, quite often I find some slicers to lose report connections without my "disconnecting" them from the pivot table(s). I have repaired Excel files many times, not really know if they needed to be repaired, but just to see if that would help. I am using 2013 64 bit. I had the same issue with 2010. Any ideas as to why I would lose report connections? I can easily reconnect them, but i shouldn't have to do that. Thank you for reading and any advice.

[jyotishukla]

Report connection me 2nd pivot table show nhi ho rahi, what should I do, please help.

[jamesearlism]

I am trying to add a slicer on my pivot table but it is showing that it is disabled/grayed-out. what do i need to do to enable it? i am using excel 2013.

[tannertucker]

Thank you David. If I create a dashboard in Power Pivot and send it to a party that doesn't have Power Pivot installed, will the non-Power Pivot party be able to use my dashboard?

[Earthwormgoodypants]

Is it possible to use slicers for pivot tables that are connected to different sources of data? For instance, I have one data source table that has claims information and I have another data table that has membership information. The claims data is more complex and has data that is not relevant to the member population (e.g. the type of claim, etc.) However, Both data tables have the same category fields that let you define the population (e.g. the region, line of business, etc.) Now, I have 2 pivot tables that reference each data source--one for claims and one for membership. I want to have one slicer that would let me filter the same population for both pivot tables, so that I could see the membership for that population in one pivot table and the types of claims for that population in another table. Is it possible to do this with slicers when the pivot tables have different sources? Even though both tables have many of the same fields, it does not seem that you can hook up slicers to both of them. It seems like you need to use the same data source for slicers, is this correct?

[aboazoz]

plase help me How to protection sheet with allow slicer? or .. How to save excel as a web page with allow slicer?

[etpangilinan]

Hi David. I'm trying to connect to my slicers to my table (connected from access), pivot table and charts and does not work. Is there a way to connect them? Like this video, where can filter your Table 1 and charts at the same time when you use your slicer

[tavei]

Hello. How did you get the diagrams (3:32)? Regards.

[renansor]

When i will add a connection, appears just one pivot table to select. How can i proceed?

[princebasha]

Bad video, can not see the menu words, low resolution