Hello,
I have 5 slicers connected to a dashboard with multiple Excel tables? Currently, I have to update 4 of the 5 slicers in order to update the charts on the dashboard. Is there a way to connect all the slicers so that am able to just update 1 of them instead of 4?
Thanks!
The slicers are built on different data sources, so there is no "native" way to join them. However you can designate one of them as a master, and when you change it, sync the other slicers to it with VBA code. It should be similar to setting the filters on a master pivot tables and syncing the other tables to it. Whether the code has to be executed manually or it can be fired automatically by an event depends on the nature of the data.
All the slicers should have the same values for variables. That is if you are selecting on a date, then all the data sets should have the same date. Otherwise you might be looking for September 6th on the selected slicer, but if a subordinate slicer doesn't have data for September 6th, you may get an error. Charts get "upset" if you ask them to plot non-existent data.
Please provide a sample workbook without sensitive data and we may be able to help.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
nice one dflak! i like your style!
Please consider:
Be polite. Thank those who have helped you.
Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks