Рет қаралды 215,757
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.