How to make a pie chart dynamically update by selecting a role from a slicer in Excel Pivot Table?

Hi everyone,

I’ve created a table in Excel using Power Query, and the table name is All-Training.
The table has the following columns:

• Process
• Training deliverables name
• Relevant to (workday role)

Here’s a small data sample:

Goal:

I want to create an interactive Pivot Table and a Pie Chart that dynamically update when I select different roles from a slicer.

Here’s what I expect:

• The slicer should allow selecting roles such as Employee, Manager, Engineer, or Analyst.
• When I select Employee, the Pie Chart should show two equal halves (50–50), because there are four training deliverables — two under Compliance Training and two under Technical Training.
• Similarly, when I select Manager, Engineer, or Analyst, the chart should update automatically to show the distribution of training deliverables across their respective Process values.

I’ve already created a Pivot Table and inserted a slicer, but the pie chart doesn’t seem to update interactively when I change the slicer selection.

Can someone guide me step-by-step on how to link the slicer, Pivot Table, and chart properly so the pie chart reflects the selected role’s data automatically?

Thanks,