Is it possible to have a seperate line on the line chart to be affected by a separate slicer?

[Anonymous]

Is it possible to create another line on the line chart to only be affected by a seperate slicer?

[Anonymous]

You can use a workaround, you can copy the line chart and turn off the background of the copy and place it exactly on top of the orginal line chart and edit the interactions of the separate slicer so that it affects only the newly created line chart.

[Anonymous]

How can I edit the interaction of the separate slicer to only affect the newly created line chart?

[Anonymous · Accepted solution]

1) Select the slicer and go to the format tab.

2) Then click on Edit Interactions.

3) These two icons will appear on top of the two line charts.

4) If you click the left icon then slicer will filter that line chart and if you click the right icon, then the slicer ignores that line chart.

Here you see that I turned off the the slicer interaction for the line chart on right side. 

So in this way I can control the interaction of the slicer so that it filters the left line chart and ignores the right line chart.

Regards,

Aditya

[amitchandak]

@Anonymous , not very clear, but you can use an independent slicer, and create a measure based on that

example

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI