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!
@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
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
