Visual to use only one slicer

[IanCockcroft]

Hi guys, doing my nut with this issue. I'm sure there is a simple fix.

Job SLA is reported on.

SLA status can be "Met" or "Missed" per job, per date.

I have 2 visuals and 2 slicers.

the 2 slicers are on date and a 

job category(level).

the one visual is a pie with SLA status for a particuar day. day is selected in the date slicer and the job category slicer.

the other visual 100% stacked column. X-Axis is by day, y-axis by SLA count and the legend SLA status.

this visual needs to show a trend overtime.

the issue is, if i select a date, the trend visual only  shows 1 day. i need it to show all the dates and still need it to be sliced by job category

How do I only use the job category slicer on the trend visual?

I have tried with DAX, but cant get it right.

i have attached a PBIX with all my attempts.

thanks a mil guys

ian

[AntonioM · Accepted solution]

You can remove the interaction between the slicer and that specific visual.

With the slicer selected, go to the FORMAT tab and click on 'edit interactions'

This will show icons next to other visuals on the page, which will let you control whether the slicer

filters

or doesn't filter