Forum Discussion
Show % difference between lines in a chart with tooltips
Hello, I have the following data in a line Chart, it has all months of 2017 and just 9 months in 2018. How can i display the sales difference in percentage between the years by month? T...
Hi Anonymous,
For another way, we could use dax to achieve that.
Measure =
CALCULATE ( SUM ( Table1[Sales] ) )
- CALCULATE ( SUM ( Table1[Sales] ), SAMEPERIODLASTYEAR ( 'Table1'[Year] ) )More details, you could refer to the attachment.
Best Regards,
Cherry
dlopesc04
Resolver II
Resolver IIIt should be noted that nowdays we have Dynamic formating, solving this issue and working for charts as well.