Filter columns in Pivot table

Hi all. I'm kinda new to Pivot tables. As you can see in the attached document, I have this pivot table. What I'd like to have is a filter where I can dinamically turn on or off the various channels in the graph, but I can't figure out how.

Can you help?

Immagine 2021-01-11 122727.png

Hi mikla,

Have you considered 'slicers'?
Whilst on the pivot table, go to insert > Slicer
In the pop-up windiw select the items you want to filter.
There you can select one, multiple (Ctrl) or all available options.
You can use multiple Slicers and select for example specific channels and/or dats or date ranges.

Hope this helps.

When you insert the Slicer, you should get all the options in the source data; columns and rows and other fields not used in the pivot table.

Was not able to open your attachment. It comes up as: Invalid Attachment specified

It is always best to upload a sample workbook (without confidential data). See yellow banner at the top on how to do this. That makes it much easier for members to exacly see what you are working with and tesp possible solutions.

Thanks for the sample file.

I have added the data series also to the 'Filters' section of the pivot chart fields.
This way they show up as 'buttons' on the chart and you can select values from there. Select 0 should hide the complete series.

Sorry, I though I did attach the file... Here it is.

Hi again,
I though of another approach. Add some check-boxes for each channel. The add an additional column to your source-data which will either show the data or nothing (ticked/un-ticked).
You then use the new calculated fields for your chart.
You will need to refresh the pivot data each time you mke changes to the check-boxes to refresh the data (his could be automated with an event macro).

I did a quick example with your data in the attached file.