Can I have two slicers that effect effect two separate data series plotted on the same graph?

[Carl]

Hello,

I am preparing a report to allow our users to compare sales figures for different offices.  Is it possible to have a single line graph showing two sets of data, both using the same x-axis, i.e. monthly?

I would like to have two slicers at the top of the page.

Slicer 1 would enable the user to select which Office data series 1 represents

Slicer 2 would enable the user to select which Office data series 2 represents

Any suggestions would be much appreciated.

Thanks

Carl

[MFelix · Accepted solution]

Hi @Carl,

You can achieve this by making a auxiliary table with date and linking it to you to data sources then add the slicers for each different dataset and you can select the values as you need:

Regards,

MFelix

[Carl]

That's great, so simple now I know how to do it.

Thanks for the prompt response.

Carl