From the course: Excel: Creating a Dashboard with Power Query (Microsoft 365)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Pivot Slicer connected to multiple PivotTables

Pivot Slicer connected to multiple PivotTables

From the course: Excel: Creating a Dashboard with Power Query (Microsoft 365)

Start my 1-month free trial

Pivot Slicer connected to multiple PivotTables

“

- [Instructor] Now we're ready to create the last part of the dashboard. What we want to do is to create two bar charts, one is for the top five customers by product category and the second is for top five sales employees by product category. So we want to show the sales value, but we want to have the product category as a slicer so that we can easily control and filter for the product category that we're interested in. For each of these, we're going to set up a pivot table. So let's think about what values and fields we need. Well we know we need the sales value. For this one we need customers, for the second one we need the employee names. We want the product category as a slicer, and we want to show both of these just for the latest month. So we need to have that as a filter. Let's go quickly and set up our calculations. I'm just going to pick a pivot table that's closest to the one that we need. This one looks good…

Contents