slicers connections

Hello, I've come across an annoying "feature" while trying to create an Excel based report. Basically, I've created a data model using Power Pivot and added a couple simple measures - Forecast Accuracy (FA) & BIAS (see screenshot). After adding them to pivot tables everything seems to be...

Hi all, Really need help since I can't solve it by myself :( I am not familiar with VBA and most of time I just try and error or search how other people write the code.. but i am stuck here. I have 4 pivot tables (ABCD) in the same sheet and connect to 2 different data sources. There are 4...

I've been a long-time Excel user (25 years) and this one has me stumped. I think I've been staring at it too long or something, but I'll be darned if I can find a way to make it work. I've created a simplified simulation of my data, which consists of the following tables and columns: Revenue...

Using Excel Pro Plus and have a large table (over 100,000 rows and 100 columns) that has been added to the Data Model. I've created several Pivot tables from the Power Pivot/Manage/Pivot Table option and had a set of 16 slicers attached to 10 Pivot Tables. They were all responding correctly to...

Good afternoon. I have a question regarding the Learn Excel - Sync Slicers from Different Data Sets video. I am trying to figure out how to get this working with 3 slicers. The slicer that I am trying to use as the operating slicer is called Slicer_Week. The other two are called Slicer_Week2...

I have 8 MSBI pivot table pulls in a workbook - 4 relate to 2014 information and 4 related to 2015 information. I want to have two different Slicers to facilitate easy updating of the information: 1. would link to the 4 2014 pivot tables to field "Month" so I can update from say 2014 Sep to 2014...

Hi Everyone... Need your help again.. I have two pivot tables and i have created two slicers and connected with both the pivot table.. PivotTable1:- Filter Month Invoice No. Rows Column Dates Values PivotTable2:- Filter Month Invoice No. Rows Column Dates spot...

Hi Excel guru's, I have two different tables which I am using to populate the dashboard. Currently I am able to add slicers only to one table. I need to write a peice of code , so that what ever values are slected in slicers on the dashboard automatically, the value for slicers for the second...

I've created a query from two tables and created 2 Pivot Tables from said query. When I create slicers for each of the pivot tables using the same criteria (e.g. Region), I cannot connect the 2 slicers so that when I update one the other will be updated automatically. I've read that for such...