Help with YoY calculation

[aggss]

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!

[Greg_Deckler]

@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