Current and potential customers on same map

Anonymous ,

Not knowing much about your data, the approach I would take is this:

1. Potential Customer data and Actual Customer data are the same thing - Customer data, so it should be in one table.
2. Add a new column at the source or in Power Query called "Customer Type" (or whatever) with the formula in a custom column that is simply ="Actual" - make it a text column.
3. Add a new column in the Excel file via Power Query (do it there vs Excel so you don't have to remember to ever do it in Excel again as new rows come in" with the same column name that is the following formula ="Potential" - make it a text column.
4. Harmonize any other columns names as necessary between the actual data and the excel file.
5. In the actual data, select Append Queries on the home ribbon, and select the Excel file.
6. Now, make sure to right-click on the Excel file query itself and make sure "Enable Load" is not checked.

Any columns that exist in the actual data that do not exist in the potential data will be null in the potential records. The reverse is also true - Excel columns will generate null fields in the actual data. 

 

But now you can simply add data and filter on the Actual/Potential, or create slicers, legends, etc.