cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tprasad1 Regular Visitor
Regular Visitor

How to display university name on map?

Hi,

 

I am working on an interactive map on Power BI Desktop which comprises of colleges/universities across the state of Georgia. I am trying to display the University Name when I hover my cursor on the locations. I can see the city, county etc. but not the university name. I tried adding the university name column to visual level filters but that didn't help either. Any ideas or suggestions on how I can achieve the same?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: How to display university name on map?

Hi @tprasad1,

 

In your scenario, you can try to use the samdthompson's suggestion firstly.

 

If you already place a field in the Legend Property, I would suggest you place university name column in Location property. If there is another field in Location property, when you drill down the report, you can see the university name. See:

 

z1.PNGz2.PNG

 

Also you can create a calculated column to concatenate university name column with another column like this ( Column = [Location] & [UniversityName] ), then place this new column in Location property.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

9 REPLIES 9
samdthompson Established Member
Established Member

Re: How to display university name on map?

Assuming you have the lat/lng for the universities, why not add name as the Legend, that way you will have the name pop up on hover-over. If the city and county are important, perhaps create a calculated column which concatenates those things with University&", "&City&", "&County.

 

//Please mark as solved if your question has been answered

ankitpatira Super Contributor
Super Contributor

Re: How to display university name on map?

@tprasad1 On top of what @samdthompson said if you have university name column in your dataset just drop it into Tooltips area for the Map visual and it will start appearing.

 

Capture.PNG

samdthompson Established Member
Established Member

Re: How to display university name on map?

Adding text fields to tool tips always results in a arithmetic count for me @ankipatira rather than a label on hover-over. Is there a trick to that?

djnww Established Member
Established Member

Re: How to display university name on map?

The Tooltips are only for aggregated data, so it won't work. The Power BI Team does need to add a 'Text' Tooltip. It will be extremely useful.

 

I think the 2nd post is your best answer.

 

Later this year, you will be able to upload your own mapping layers which should hopefully allow you to add landmarks.

 

Cheers,

DJ

KHorseman Super Contributor
Super Contributor

Re: How to display university name on map?

You can drop a measure that returns text into the tooltip.

 

University Name = FIRSTNONBLANK( TableName(UniversityName), 1)

 

Assuming whatever you're using as your data point on the map corresponds to one university that will work. If it's an area that contains multiple universities (I dunno, maybe you have a hierarchy where they can drill up to the state or province) it will show the first university name in your table for that region.


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
samdthompson Established Member
Established Member

Re: How to display university name on map?

@KHorseman can you conactenate together the firstnonblank returns in the measure so you get the University, the City & the County?

KHorseman Super Contributor
Super Contributor

Re: How to display university name on map?

@samdthompson I don't see why not. I'm sure it would work if you did something like

 

University = FIRSTNONBLANK(TableName[UniversityName], 1) & ", " & FIRSTNONBLANK(TableName[City], 1) & ", " & FIRSTNONBLANK(TableName[County], 1)

 

...though I haven't actually tested this exact case.


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
Moderator v-qiuyu-msft
Moderator

Re: How to display university name on map?

Hi @tprasad1,

 

In your scenario, you can try to use the samdthompson's suggestion firstly.

 

If you already place a field in the Legend Property, I would suggest you place university name column in Location property. If there is another field in Location property, when you drill down the report, you can see the university name. See:

 

z1.PNGz2.PNG

 

Also you can create a calculated column to concatenate university name column with another column like this ( Column = [Location] & [UniversityName] ), then place this new column in Location property.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

dsandberg Regular Visitor
Regular Visitor

Re: How to display university name on map?

This solution was perfect for me. I was looking for a solution to add a text label to a map dot.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,790)