Show difference between 2 curves

[Arkhos94]

I have a basic graphic visual that show the YTD performance each year. I want to show the difference between the December performance of 2021 and 2023 (like in the picture below), is there any way to add that ?

I already have a measure that calculate the difference between any YTD performance and the one from December 2021 (that is used as a reference)

[Arkhos94]

I build a measure that show "Current performance (difference with 2021-12 performance" and put it on the graph using the new label option, thanks for the idea

Is there any way to show an arrow like I added on my picture ?

[Anonymous · Accepted solution]

Hi @Arkhos94 ,

Thank you for @amitchandak answer , and I have other suggestions for you:

First of all, thank you for creating a measure about Difference with 2021-12 Performance, but there is currently no way to add a difference arrow to the line chart, it can only be displayed in the tooltip.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Arkhos94]

Thanks, i hope such a function will be added some time in the future then

[amitchandak]

@Arkhos94 , You can use the new detailed option in label and display YTD diff. but it will show for all values. Noy you can control that display on last month.

if(Max(Date[Month]) = maxx(allselected(Date), Date[Month]) ,[YTD Diff], blank()) 

New Power BI Data Label Customizations (December 2023) - Enhance Your Data Analysis & Reporting:
https://www.youtube.com/watch?v=qe3eW4OkAN8&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L