Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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!
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!
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |