Forum Discussion

brysonb12's avatar
brysonb12
Frequent Visitor
3 years ago

Data Slicer Filtering

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! 

5 Replies