Forum Discussion

jayeckles's avatar
jayeckles
Advocate III
9 years ago
Solved

Displaying a key on custom shape map

I'm using a TopoJSON file that represents the state house districts in Tennessee.  Among the keys in that map are geoid, name, etc.  I'm using geoid for the location field.  When you hover over an ar...
  • jayeckles's avatar
    jayeckles
    9 years ago

    Thanks.  I ended up adding the place name to my data set and then using this formula for a new measure:

     

    District Name = VALUES(districttest[districtName])

     

    I added that measure to the Tooltip, and it displayed as expected.

     

    I appreciate the assistance!

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi jayeckles,

 

Yes, tooltip values can only be summarized numerical values or count of text values. If you want display the name in the map, you’d better create a measure and use it in tooltips by the following formula.

Names List Measure = CONCATENATEX ( VALUES(Table[NameColumn]), Table[NameColumn],", ")


This formula will work for 1 or many names associated with that location.


Best Regards,
Angelia

  • jayeckles's avatar
    jayeckles
    Advocate III
    9 years ago

    Thanks.  I ended up adding the place name to my data set and then using this formula for a new measure:

     

    District Name = VALUES(districttest[districtName])

     

    I added that measure to the Tooltip, and it displayed as expected.

     

    I appreciate the assistance!