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, 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

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

2 Replies

  • 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