Hello,

I wanted to have one of my slicers only show 2 of the options.

Im not sure if this is possible by regular settings so is there a code to put when the filter is cleared to auto filter those 2 options?

slicer has "Interco", "Direct" and "Indirect" and I only want the "Direct" and "Indirect" to show in my charts, never Interco.

Thanks.