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
v-piga-msft
Resident Rockstar
Resident RockstarHi 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