ArcGis Bubble Size 2 Tables

[tomperro]

On an ArcGis map, I need to display a count (separate bubble size & color) from two different tables.

I have the following tables:

1. Location_Lat_Lon - This is my master table that contains the latitude and longitude of each of our site locations. I have a column that combines the name of our location with a milepost (this field is in each table to link them all together).

2. Event Table 1 - contains field that concats our Location name with a mile post and also has events by date and an ID for each event.  I will use the count of each event.

3. Event Table 2 - contains field that concats our Location name with a mile post and also has events by date and an ID for each event.  I will use the count of each event.

I need to show how many events from table 1 have occured and seperatly how many events from table 2 have occured (each by bubble color and size) at each location.

Blue bubble will show how many events from table 1

Red bubble will show how many events from table 2

[v-yiruan-msft]

Hi @tomperro ,

You can refer the following links to get it:

Power BI ArcGis Map will not map both size and color

ArcGIS Map in Power BI; Simple, But Insightful

If the above one can't help you get the desired result, please provide some sample data in your tables Location_Lat_Lon, Event Table 1 and Event Table 2(exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards