Forum Discussion
Multiple bubbles in same location map
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.
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.
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.
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.
\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?
Hello, rsch91 ,
can you perhaps add some sample data, maybe I'll figure out a way.