cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jayeckles
Advocate II
Advocate II

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 area in the map visual, the tooltip shows you the value for geoid and the value for color saturation.  So far, so good.

 

What I want to show in the tooltip instead of geoid is name.  E.g., instead of showing "geoid: 47014 / count: 2", I want the tooltip to show "name: State House District 14 / count: 2".  As a consolation prize I'd take showing the name in addition to geoid.

 

I know that I can add fields to tooltip in the fields well, but that's insufficient.  For one, it appears that the tooltip values can only be summarized numerical values.  Even if I had a field called name in my data set, if I drag that to tool tips, I end up with count of name.

 

1 ACCEPTED SOLUTION

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!

View solution in original post

2 REPLIES 2
v-huizhn-msft
Microsoft
Microsoft

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

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!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors