Drill Down Map with two sets of coordinates

[RobKWW]

Hey there,

I have got a small problem and can't find a solution. I would like to represent a geographical organization of different companies in a map. In the main table I have all company locations with location type (e.g. field service center, main supply center, ...). The dependencies between these locations are stored in an additional table with one column for the underlying location and another column for the managing location.
The goal is to have a map in which only all managing locations are shown. Then you choose a managing location and should be able to drill down to all underlying service locations.

I am able to create different views for this task (e.g. one view representing all managing locations and another one representing the underlying locations with a reference to the managing location). As a boundary condition I assume that all underlying locations have only one managing location and there is a clean cut between managing and underlying locations.

Maybe someone had a similar issue and could provide a solution.

Beste regards

[RobKWW]

Hi Henry @v-henryk-mstf ,

thank you for your answer. I have tested your solution but I can't apply the last step. The location information I have in my dataset is only given in longitude and latitude. Thus I can't add them to the location information.

I am able to create a map with all managing locations from the whole location dataset by adding a filter to the managing location.

Following you can find an example dataset for the location structure.

Could you be so kind to evaluate your last step a bit more?

ShopID	ShopName	ShopLat	ShopLon	ShopType
1	FieldCenter1	8,88772	52,75792	small
2	FieldCenter2	8,79807	52,50369	small
3	FieldCenter3	9,53903	52,10057	small
4	FieldCenter4	9,15665	51,94435	small
5	FieldCenter5	8,9503	52,3025	small
6	FieldCenter6	9,2036	51,852	small
7	FieldCenter7	9,25213	52,75792	small
8	FieldCenter8	8,9988	52,50369	small
9	MainCenter1	8,8216	52,10057	big
10	MainCenter2	9,1058	51,94435	big
11	MainCenter3	9,4421	52,3025	big
12	MainCenter4	9,493	51,852	big
13	MainCenter5	9,035	52,4204	big

ManagingShopID	UnderlyingShopID	ConnectionType
9	1	Supply
10	2	Supply
9	3	Supply
11	4	Supply
10	5	Supply
11	6	Supply
13	7	Supply
12	8	Supply

Best Regards,

Robin

[v-henryk-mstf]

Hi @RobKWW ,

To create a map in Power BI that shows only the managing locations and allows you to drill down to the underlying locations, you can follow these steps:

• Import your data into Power BI and create a new report.
• Add a map visual to the report and select the columns containing the location information for the managing locations as the location data.
• Use the filter options in the map visual to show only the managing locations.
• Create a new view that shows the underlying locations and add a column to this view that indicates the managing location for each underlying location.
• Add a drill-down group to the map visual and use the new view as the drill-down level. This will allow you to drill down from the managing locations to the underlying locations.

You can also use other Power BI features, such as slicers and visual interactions, to further customize the map and make it easier to navigate and explore the data. For example, you could use a slicer to filter the managing locations shown on the map, or you could use visual interactions to enable users to click on a managing location on the map to see the underlying locations for that location.

If the problem is still not resolved, please provide detailed error information and test sample data. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.