Forum Discussion

david2's avatar
david2
Icon for Helper I rankHelper 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.

     

v-micsh-msft's avatar
v-micsh-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi david2,

 

Well, as the Map visual identify the location based on the postal code, so currently I don't think having the 3 people in the same location displayed in 3 bubbles.

 

For Question 2, I could think out a way to deal with that, which would need to know how the data table you stored for the locations and the partners.

For example, if the data table is somehow the structure below:

LocationPeople
A1
A2
B3
C4
C5

 

Then we may write a measure to show the names, when location contains more than one partner value, we concatenate the name string into one, with this the visual should be able to display the 3 partner names.

Partnername = CONCATENATEX(VALUES('Table'[Partner]),'Table'[Partner],",")

Put this measure into Tooltips.

If this is not working, please share your data model, and we will help to check.

Regards

  • david2's avatar
    david2
    Icon for Helper I rankHelper 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
      Icon for Community Champion rankCommunity 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
        Icon for Helper I rankHelper I
        9 years ago

        Works like a charm! Thanks Vvelarde :-)