Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I'm trying to do an actual vs budget income statement. However, despite my attempt at creating the relationships between the dates in the budget and actual dates (field MonthYear) with a date table, when slicing for a specific month, I'm getting the right data for the actual but not the budget. I also tried slicing by MonthYear in budget, nothing happens with the actual data.
Here's a link to my pbix: https://drive.google.com/file/d/1m4eQXsuwwpXhMJ2YgUB6gpERkngzINbJ/view?usp=sharing
Can someone kindly help me?
Thanks in advance
Solved! Go to Solution.
Your date slicer needs to use DateTable, not Actual. This will allow the filter from DateTable to flow through to the Actual and Budget tables.
Proud to be a Super User!
Thank you!
Your date slicer needs to use DateTable, not Actual. This will allow the filter from DateTable to flow through to the Actual and Budget tables.
Proud to be a Super User!
User | Count |
---|---|
86 | |
82 | |
68 | |
67 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |