Forum Discussion

rsch91's avatar
rsch91
Helper I
1 year ago
Solved

Multiple bubbles in same location map

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. 

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    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. 

8 Replies

  • vojtechsima's avatar
    vojtechsima
    Super User
    1 year ago

    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's avatar
      rsch91
      Helper I
      1 year ago

      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's avatar
        vojtechsima
        Super User
        1 year ago

        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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
      rsch91
      Helper I
      1 year ago

      Thank you. I have submitted the idea 🙂