I have a set of fact tables that has information that includes the division the unit is in, name of unit, overall risk score and then the various values used to arrive at the score.  I've added a dim table listing each  division and the divisional name and have linked the various fact tables to the dim table by division.  There is currently one division with no information on any of the fact tables but all other divisions have multiple entries on the fact tables but only one entry per division on the dim table.

I have set up two pivot tables to show the risk score and unit name for two types of units from their fact tables and then added a slicer for the division using the dim table for the slicer but when I click on a division to get the pivot tables to show just that division, it doesn't do anything.  I have gone into pivot table connections and made sure both pivot tables are checked, even when it is just one or the other checked nothing happens.

I double checked and the relationships look set up correctly dim table is the 1 and the fact tables the multiple.  

I tried using the division from one of the fact tables as the slicer and then that pivot table will filter but when I try to connect it to the second pivot table, it will filter the first but not the second one. Mu understanding is that I should set the slicer up from the dim table but have no idea why it isn't work.  It worked when I did the sample lesson but on my data, no luck.

Any suggestions.

Sorry it is a couple of really big files and information I cannot really share on a somewhat public platform so I cannot attach the files.

Karen