Data Slicer Filtering

[brysonb12]

Hello All - Need some HELP!!!!!

What I have is two spreadsheets

1. Master - Holds multple weeks of data

2. Current - Is a copy of the (Master) but have set a filter to it to just show me the data from the most current week ending date.

I have a sheet that has multiple charts on it. Most of the charts are based on the "Current" table. But there are also some charts that are based on the Master table.

I have included multiple slicers to sort through data. (Company, Department, Area, Team)

What I am trying to do is when I select Company, i want the Department slicer to filter only based on the data that is there, and the charts to reflect the selection. 

The issue is when I apply the Comapny from the Current table it only chnages those graphs (Current) and vise vera for the Master. 

I haver also created a "Company" table of its own, and then linked "Company" to both the Master file and Current. That dont work either......

Looking for suggestions! 

[brysonb12]

[CharbelArmaleh]

Hello,

this is not the model

it should contain the tables and the relations 

Regards 

[CharbelArmaleh]

Hello

can you show us the model ?

[brysonb12]

Hopefully someone can help fix!!! Not sure why its not filtering the data.

[brysonb12]