Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |