Choosing multiple values on chart

[missasuna]

Hi,

I've got multiple line charts with multiple values on it (values are simple columns). I would like to use slicer to switch between displayed values or choose which values should be displayed but I don't know how to do it. 

Any solution? 

[BhaveshPatel]

Can you please post sample data/chart AND expected output.

[missasuna]

I would like to use that slicer to manipulate displayed values (sometimes I don't want display all)

[BhaveshPatel]

You can edit the interactions of the chart but to completely disappear them is not possible as far as I know. To Stop interactions of the slicer with the visuals, select the visual and Go to the Format Tab, Select Edit Interactions, Select the unselect the filter button on top of the visual anf select the stop button on the report next to the filter button.

Hope this will make your understanding clear.

[missasuna]

Thanks for your answer but I think I didn't ask question clearly. The solution on screenshot is my expected output.  Slicer on screenshot is fake. My question is: Can I get slicer from the screen? My slicer from the screen should have names of columns (not all from the table but columns picked by me) instead of values of one column. Expected action: If I chceck one of box, one of the line will appear. 

Single line in my chart is represented by simple column with random numeric values.

[BhaveshPatel]

To do so, You need to do some workaround in the Query Editor, 

Go to Query Editor, Select Home Tab, Select Sample 1, Press Unpivot this Column, Give a meaningful Names to Your newly created Columns.

Repeat this steps for Sample 2 and Sample 3 Column.

Load your query after you are finished with this and

You can use this newly created columns as slicers.