Why isn't my map working?!?! [Workaround for adding interactive maps to Excel dashboards]

0:00 The goal: Make a dynamic map for an Excel dashboard 0:20 What doesn't work: From a pivot table directly to a map 1:14 Anything's possible in Excel with the right workaround 1:29 The usual workflow: Dataset to pivot table to pivot chart, with a slicer 2:36 The workaround: An intermediate step called a Helper Table 2:58 What's needed for the Helper Table 4:17 Working backwards: Setting up the pivot table to match the Helper Table 4:27 Subtotals and Grand Totals: Off 4:35 Report Layout: Outline and Repeat All Item Labels 4:54 Blank Rows: Off 5:07 Dynamic Array (a direct link with a dot) 5:49 Add a Slicer to the Pivot Table 6:23 Filling in 254 "United States" entries -- based on the state with the most counties (Texas) -- because that's the most possible United States entries we'd ever need 6:53 Highlighting County and Variable A in the Helper Table and inserting a map 7:37 Slicers can be added to Tables, pivot tables, or pivot charts -- I always recommend adding them to pivot tables 7:55 Drawing how everything is connected: Dataset into pivot table, slicer added to pivot table, pivot table and slicer controlling the Helper Table, Helper Table feeding into map 8:34 Slicer(s) and maps/charts get cut and pasted onto their own Dashboard sheet 8:52 Recap of key points