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
Fabric Community Update - November 2024
Find out what's new and trending in the Fabric Community.
Be one of the first to start using Fabric Databases
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Power BI Monthly Update - November 2024
Check out the November 2024 Power BI update to learn about new features.
| User | Count |
|---|---|
| 94 | |
| 86 | |
| 81 | |
| 70 | |
| 49 |
| User | Count |
|---|---|
| 143 | |
| 124 | |
| 107 | |
| 60 | |
| 55 |
