Power Map From Two Data Sets
June 21, 2018 - by Bill Jelen
A question from my Melbourne Florida Power Excel seminar: Is it possible to display two different data sets in Excel Power Map (Excel 2013) or Excel 3D Map (Excel 2016+)? I knew this was possible because I've seen it in a Microsoft demo. I just wasn't sure how Microsoft did it.
The trick is to add each data set to the workbook Data Model before creating the map.
First, select one cell in your first data set. Press Ctrl + T to Format as Table. Make sure that box for Use First Row as Headers is checked. Repeat for the second table.
Adding the data to the data model could be very simple if you have a tab in the Excel ribbon called Power Pivot. In May 2018, Microsoft announced that all versions of Office 365 would soon have this tab. If you own the perpetual version of Office 2013 or Office 2016, you might not have the tab. If you have the Power Pivot tab, follow these steps: