Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have data in one excel workbook but my information is on 3 different tabs. One with Actual, LY, Budget. When I try and gather all the information on the one graph, it makes one of the tabs the lead and keeps the information for the other tabs static.
Example.
Actual vs LY YTD works fine, until I try to bring in product details which are identical for both years. It only breaks the column down for one, not both. So one is showing me the sales by product and the other is showing me total sales. What am I doing wrong?
The requirement is not very clear. You might need to check the relationship.
User | Count |
---|---|
94 | |
79 | |
73 | |
63 | |
60 |
User | Count |
---|---|
108 | |
100 | |
77 | |
63 | |
61 |