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.
Hi all,
I have a map with various locations on it - e.g.:
UK | Dave |
France | Gill |
Spain | Francis |
UK | Moira |
Finland | Han |
(it goes on for longer...)
And I'd like to label the bubble map with more than just the country name when I use it as a location, so thought that I could combine the country name and a count of the country name into a single calcuated column so the end result would be
UK 2
France 1
Spain 1
Finland 1
And I could then combine these into the single field that I could use as location so that the data labels would read "UK: 2" as opposed to just "UK".
I feel like I am missing an obvious trick here and being dim, but any guidance would be appreciated.
Solved! Go to Solution.
Sorry for the slow reply, I had issues logging in.
I wanted to data to be displayed on the map without requiring a tooltip (so I could capture the image and share it and not lose the info), so I needed a calculated column:
Sorry for the slow reply, I had issues logging in.
I wanted to data to be displayed on the map without requiring a tooltip (so I could capture the image and share it and not lose the info), so I needed a calculated column:
If you create the measure
If you want just the formatted measure as the tooltip you can get that using a custom tooltip page.
Quickly the result would be
But once you get into custom tooltips there are plenty of options available to make the tooltip look/say what you want.
Proud to be a Super User! | |
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 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |