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!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
