Forum Discussion
How to create mirrored YoY chart with % difference trend?
Is it possible to create something like the above graphic in Power BI? The top would represent values from this year, the bottom would represent values from the previous year. And the trend line would be a percent difference of the two years.
And would it also be possible to have a custom range of dates on the graph, where the user can choose the last X months/years and the bottom half would show the same duration (e.g. user selects past 6 months, from Jun '24 - Nov '24, then the bottom will show Dec '23 - May '23 and the trend will compare the difference between the two).
Hi Gerbil ,
Try using line and stacked column charts.
Take last year's value negative, but fix it over in the data label.
Previous year value data label = CALCULATE([Current year value], DATEADD('Date'[Date], -1, YEAR))Previous year value = -[Previous year value data label]I attached a pbix file for your reference.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
1 Reply
Hi Gerbil ,
Try using line and stacked column charts.
Take last year's value negative, but fix it over in the data label.
Previous year value data label = CALCULATE([Current year value], DATEADD('Date'[Date], -1, YEAR))Previous year value = -[Previous year value data label]I attached a pbix file for your reference.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum