Pivot click line -> show selected value in chart

Hi all,

quick question. I created a sheet with a pivot table as well as a stacked combo chart to view performance data.
I have added a filter to the whole sheet to select specific peoples to review their performance but i was wondering if there is a possibility to select/click on a name in the pivot and the chart get updated automatically to show only the selected person instead of using the filter? Is that possible?

Hi @David_Goumah, yes, that is possible by configuring a filter action from the interaction menus for your pivot table.

Following is an example from my demo environment.

  1. Click on format visual, and then under interactions tab, add action.

  2. Configure filter action by selecting a column you want to filter, then save.

  3. You can click on the person name that you wan to filter to. Then, combo chart will show only the relevant data.

Thank you very much very helpful and well explained