Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Including additional plot on line graph using a slicer

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

 

Need Help
  • rajulshah's avatar
    rajulshah
    6 years ago

    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's avatar
    rajulshah
    6 years ago

    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.

4 Replies

  • rajulshah's avatar
    rajulshah
    Resident Rockstar
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        rajulshah
        Resident Rockstar
        6 years ago

        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.