Power BI - Maps: Multiple markings using different dataset

[send2prasan]

Dear All,

Struck with some problem related to Power BI Mapping

The hirarchy of the data is something like this:

Area ==> Church ==> Pioneer

Each Area is having one or more churchs and each church is having one are more PioneersEach entity is having individual lat and log. Please refer the tables below:

Projects Table
ProjectId	ProjectName
1	Proect1
2	Project2

Area Table
AreaId	AreaName	ProjectId	Latitude	Logitude
1	Area1	1	12.29581	76.639381
2	Area2	2	12.30587	76.73481

Church Table
ChurchId	ChurchName	AreaId	Latitude	Logitude
1	Church1	1	12.31593	76.830239
2	Church2	1	12.32599	76.925668
3	Church3	2	12.33605	77.021097
4	Church4	2	12.34611	77.116526

Pioneer Table
PioneerId	PioneerName	AreaId	ChurchId	Latitude	Logitude
1	Pioneer1	1	1	12.33605	77.021097
2	Pioneer2	1	1	12.34611	77.116526
3	Pioneer3	1	2	12.35617	77.211955
4	Pioneer4	1	2	12.36623	77.307384

Project Status table
Id	PrjectId	AreaId	ChurchId	PioneerId
1	1	1	1	2
2	2	1	1	2
3	1	1	2	4
4	1	1	2	4

The requirement is to map all these entities with different icons on Power bi Map and on hover it has to display count of the projects completed by each entity:

Area1 (Project1): 3
Area1 (Project2): 1

Church1 (Project1): 1
Church1 (Project2): 1
Church2 (Project1): 2

I trust to best of my knowledge I have explained the requirement. Your help will be appreciated.

Thanks,

Prasanna V.

[v-jiascu-msft]

@send2prasan,

Hi Prasanna V.,

Based on your data, I created a sample model. I am afraid we can't change the icon by now. Maybe we could use colours instead. Maybe you could vote an idea here: cusom-markers-on-maps.

1. The relationships would be like this:

2. We need two map visuals here.

Best Regards!

Dale

[send2prasan]

Dear Dale,

Good morning. Thanks for the input.

The requirement is to mapp all these entoities on single map not using multiple maps. This is a kind of hierachy.

Area is on the top

Followed by church and pioneer.

I have a Project filter LHS and on selection it should mark respective Area, Church and Pioneer on the map. on hovering it should display count of project.

Thanks,

Prasanna V.

[v-jiascu-msft]

@send2prasan

Hi Prasanna V.,

How should I show the Pioneers in the map? It seems that we can't custom icons by now. Could you please create an idea or vote one here: cusom-markers-on-maps. Maybe we can get it in the future.

Best Regards!

Dale

[send2prasan]

Dear Dale,

It should look something like this:

Area 1 ==> Red bubble

    Church 1 ==> Blue bubble

        Pioneer 1 ==> Green bubble

        Pioneer 2 ==> Green bubble

    Church 2 ==> Blue bubble

        Pioneer 3 ==> Green bubble
        Pioneer 4 ==> Green bubble

Thanks,

Prasanna V.