Forum Discussion

david2's avatar
david2
Helper I
9 years ago
Solved

Map visual: preventing piechart and showing data in tooltip

Hi all,   I have a table with partner companies which has the following columns (among others, that are irrelevant for this visual) painterName Phone number location (Zip Code (PLZ), in Germany...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    david2

     

    Create a new column

     

    partnersData = Table1[PartnerName] & "-" & Table1[Status] & "-" & Table1[phone]

     

    Next create a measure:

     

    PartnersInfo = CONCATENATEX(Table1,Table1[partnersData],"|")

     

    Use this measure in tooltip area.

     

david2's avatar
david2
Helper I
9 years ago

Hi v-micsh-msft,

 

Thanks for the quick reply. I was already afraid that plotting 3 bubbles on the same location would not be possible, since 3they would overlap. I guess we'll have to start collecting a more detailed address of our partners anyway.

 

Regarding your answer on question 2, my table is structured as follows (simplified example):

 

 

Ideally, i would like the bubble on location 10001 to show something like "John - Active - 12313123; Pete - Interested - 12313123; Mike - Active - 12313123".

 

 

Any idea how to achieve that?

 

Best,

 

David

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

david2

 

Create a new column

 

partnersData = Table1[PartnerName] & "-" & Table1[Status] & "-" & Table1[phone]

 

Next create a measure:

 

PartnersInfo = CONCATENATEX(Table1,Table1[partnersData],"|")

 

Use this measure in tooltip area.

 

  • david2's avatar
    david2
    Helper I
    9 years ago

    Works like a charm! Thanks Vvelarde :-)