Choosing multiple values on chart

Question

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&nbsp;but I don't know how to do it.&nbsp;Any solution?&nbsp;

bhaveshpatel · Answer

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

missasuna · Answer

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

bhaveshpatel · Answer

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 · Answer

Thanks for your answer but I think I didn't ask question clearly. The solution on screenshot is my&nbsp;expected output. &nbsp;Slicer on screenshot is&nbsp;fake. My question is: Can I get&nbsp;slicer from the screen?&nbsp;My slicer from&nbsp;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.&nbsp;Single line in my chart is represented by simple column with random numeric values.

bhaveshpatel · Answer

To do so, You need to do some workaround in the Query Editor,&nbsp;&nbsp;Go to Query Editor, Select Home Tab, Select Sample 1, Press Unpivot this Column, Give a meaningful Names to Your newly created Columns.&nbsp;Repeat this steps for Sample 2 and Sample 3 Column.&nbsp;Load your query after you are finished with this and&nbsp;You can use this newly created columns as slicers.&nbsp;&nbsp;

Forum Discussion

Choosing multiple values on chart

5 Replies

Related content

Waterfall with multiple values

Text slicer: pasting multiple values

ISFILTERED multiple values

Slicer for Multiple-Choice Values

how to dynamically replace values for multiple columns