March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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 ?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
87 | |
84 | |
77 | |
49 |
User | Count |
---|---|
160 | |
144 | |
103 | |
74 | |
57 |