Forum Discussion
Help with YoY calculation
I'm trying to show the YoY in a bar chart for each month over the last three years. And I'm having two problems.
1. This works great until I filter to the last three years and then the YoY for 2022 gets messed up. How can I see the YoY for 2022 without showing 2021?
2. My data isn't complete for July to December 2024 - though there are values for some dimensions. How can I dynamically filter these months out of my visual? I'm reporting the amounts for 7 countries and I want all 7 to have data for the month before I report on it.
Don't judge the colors, I haven't gotten to that part yet!
1 Reply
aggss So, typically this can be solved using ALL but hard to know for certain without more information. See if these help: Better Year Over Year Change - Microsoft Fabric Community
