Line Chart and Filter Selection

[dmorgan26]

Hi all,

I'm trying to create a line chart that can show up to 20 different lines of sales over time (the chart will be large enough to see them all!).  There data set looks like below:

Date	Location	Sales
1/1/20	City A	50
1/1/20	City B	40
1/1/20	City C	32
1/2/20	City A	44
1/2/20	City B	55
1/2/20	City C	31

There are hundreds of cities in the data set so I'm using a Filter pane for the user to select the cities to display.

I have followed this guide to create two filter panes, each with its own 'alternative state' here: https://www.youtube.com/watch?v=LMMGAFgrnc8 

How can I adapt this to use just one Filter pane where each city selected produces its own line on a line chart? 

Any help is greatly appreciated! Thanks