compare serveral years with one slicer

[Pete230]

Hi there,

I'm struggeling with the following:

I would like to display monthly data over several (up to 10) years  in a line chart. But I do not want to see them all in line from e.g. Jan. 2013 to Dec. 2019, rather I would like to see them as comparison (so I see only the months Jan. - Dec. on the x-achsis and the to be compared year-lines distinguished by color). So in the end I do have a slicer to compare as many years as I m choosing in the slicer.

What I did find is a solution that compares two years via to slicers (https://www.youtube.com/watch?v=QPVSxxoN5sg). I'm hoping that there's a solution to combine more than 2 years with just one slicer.

Does anyone know a propper solution to that?

Thanks in advance and regards

Pete

[Pete230]

@johnt75that was an easy one, works perfectly, thanks a lot!

[johnt75 · Accepted solution]

I think you can add the month name column from your date table to the x-axis and the year column to the legend. also put the year column in the slicer and you should be able to choose as many or as few years as you want.