Hi Folks,
I have a line chart like this below. Is there any way to add an YOY comparison when i hover over?
i have attached my dummy data table.
Thank you in advance!
Hi Ben,
Follow the steps below:
1. Holding down CTRL key and taking "Sales" pill and dragging it to "Tooltip" mark card - this will duplicate the pill (you can also simply take the "Sales" pill from Measures and add it to tooltip)
2. In the 2nd pill on Marks card for "Sales" right click it and Go To - Quick Table Calculation > select "Percent Difference"
3. Hover over to any points on the view and the Tooltip now has % difference shown compared to previous Month same year.
Attached is solution workbook created in version 10.5
Hope this helps. If it does please mark the answer correct. Thank you.
Best regards,
Ankit
