Forum Discussion

Carl's avatar
Carl
New Member
9 years ago
Solved

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

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,...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    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

MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

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's avatar
Carl
New Member
9 years ago

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

 

Thanks for the prompt response.

 

Carl