Compare annual revenue in one chart using two slicers for the years

NickOnTheNet

New member
Joined
Feb 3, 2018
Messages
1
Reaction score
0
Points
0
Hi all!
I am just looking for a pointer to a suitable youtube video or resource to help with the task in hand.
(I am certain I have seen something covering this in the past but there is just so much out there!)
I want to compare two years revenues by customer and product in one pivot chart, but I also want to control which years are displayed by using two separate slicers. That way I can compare say 2010 with 2014.
The icing on the cake would be to have the corresponding year in one slicer disapearing when selected in the other! (But hey, no icing is good too!) :smile:
My data is already in the Data Model with sale date, product, customer and revenue in the cols.
Thanks for your time guys!
 
Nick

Consider sending some fake data with same structure, it makes things 10 times easier and often means that you get an answer within the day
 
Back
Top