Including additional plot on line graph using a slicer

[Anonymous]

Hi

I have a table which looks like

Value       Name

0.1            A

0.25          B

0.3            A

0.5            A

0.4            B

0.1            C

0.2            C

0.3            A

I would like to be able to plot a graph that filters the data using a slicer. I.e If A is selected plot only A, if A and B are selected show two lines etc

Cheers

[rajulshah · Accepted solution]

Hello @Anonymous,

You just need to add slicer having 'Name' field and use that field in the graph. It will work as you expected.

[rajulshah · Accepted solution]

Hello @Anonymous,

You just need to add slicer having 'Name' field and use that field in the graph. It will work as you expected.

[Anonymous]

Sorry I forgot to add that there is a column with time in it, and I am plotting a time vs value. When I add the slicer it just aggregates these values together, it doesnt add a seperate line

Time     Value       Name

1            0.1            A

2            0.25          B

3            0.3            A

4            0.5            A

5            0.4            B

6            0.1            C

7            0.2            C

8            0.3            A

[rajulshah · Accepted solution]

Hello @Anonymous,

I am able to achieve this on the basis of your sample data.
Please use Line Chart > use Axis - Time, Legend - Name and Values - Value.

And then use 'Name' in slicer.

Let me know if this didn't work.

[Anonymous]

Ah yes, that works great. Thanks a lot