Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Hello,
this is not the model
it should contain the tables and the relations
Regards
Hello
can you show us the model ?