Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |