Forum Discussion
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
- CharbelArmalehResolver II
Hello
can you show us the model ?
- brysonb12Frequent Visitor
- CharbelArmalehResolver II
Hello,
this is not the model
it should contain the tables and the relations
Regards