Multiple bubbles in same location map

[rsch91]

Hi,

I have a question regarding the map visualisation. I have multiple addresses in one building which are plotted on the location. The legend is the type of rental contract these adresses have. 

Some addresses are on the same lat-long location, just on a different floor. The bubbles corresponding with those addresses will overlap, creating a weird colour if there's different types of rental contracts in that location. How do I fix this? I want to show a separate bubble for each address. 

Thank you. 

[Anonymous · Accepted solution]

Hi @rsch91 ,

Thanks vojtechsima  for the quick reply. I have some other thoughts to add:

Unfortunately, so far, to my knowledge, this may not be achieveable. 

You can post your idea to Ideas.  https://ideas.powerbi.com/ideas/

Here is an alternative for your consideration:

You can use the form visual object to show different types of rental contracts for the same address. You can filter directly by clicking on the bubbles or you can use the slicer.

Best Regards,

Neeko Tang

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

[rsch91]

Thank you. I have submitted the idea 🙂

[vojtechsima]

Hello, @rsch91 ,

well quick solution would be to don't use Rental Contract, but just the address, or somehow trim the floor for the same type addresses and make the addresses the same.

[rsch91]

Thanks, unfortunately I need to show the rental contract on the map. & I can't change the data structure as it's all managed by the company I work for. 

[vojtechsima]

@rsch91 
then you can try to write your measure that would ignore the floors and just focus on the rest, something like this:

CALCULATE(
SUM('table'[Count]),
ALL('table'[floors])
)

 Basically whatever makes the address different (floor) etc, you wanna ignore that using ALL function.

[rsch91]

\thank you. I thought of that too, but unfortunately that's not the solution as there is ten thousands of addresses and each building has a different way of numbering the floors. There is no option in the visual itself? 

[vojtechsima]

Hello, @rsch91 ,
can you perhaps add some sample data, maybe I'll figure out a way.

[rsch91]

I'm afraid I can't, due to privacy regulation. I don't have sufficient enough knowledge to make some sample data myself as I don't really exactly know how PowerBI plots. But v-tangjie-msft has already answered saying it's not currently possible. Thanks for your help though!