cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dibbkd
Frequent Visitor

Labels on Maps

I have a few thousand addresses for all my clients, and also a couple addresses for our clinic locations.

 

I want to have a map that shows my clients in blue and my clinic locations in red.

 

I have a table of addresses for clients and a separate smaller table for my clinic location addresses.

 

I do already know how to make a single map, but not sure how to make some locatoins be different colors than others.

7 REPLIES 7
Super User IV
Super User IV

Re: Labels on Maps

Hi there, what you can do is if you have both of your clients addresses and clinic locations in one table, you could add a conditional column which would be for example called "Classification" and if it is a customer then it would be classified as "Customer" and if it was a clinic then classified as a "Clinic"

 

Then when you create your map you could then and put the Classification under the "Legend"

 

As with the attached picture, you will see that I have my Amount under Size, and then under Legend I have got my Fiscal Date, which shows in all the different colours.

PBI - Map.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog
dibbkd
Frequent Visitor

Re: Labels on Maps

Hey thank you, that does work.

 

But still wondering how to do it with two tables, because my client addresses has a bunch of other information that my clinic locations doesn't have, and also just wondering how to do it with two tables to learn another way.

 

Appreciate your knowledge!

Super User IV
Super User IV

Re: Labels on Maps

Hi there

 

If I understand correctly, can you not create 2 maps with different requirements?

 

So that each map is representative of what you are trying to achieve?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog
dibbkd
Frequent Visitor

Re: Labels on Maps

I want one map that shows my clients (a few thousand of them), and also shows my several clinic loations in another color.   I have a mySQL database I'm pulling the client info from, and a separate small table with my clinic locations.  I don't want to have to edit the client table to add my clinic locations each time, and also they contain different information besides the address.

Super User IV
Super User IV

Re: Labels on Maps

Hi there what I can suggest is in your client data, to add a Custom Colum called "Classification" and put in there "Client"

 

Next for your Clinic Locations data add a Custom Colum called "Classification" and put in there "Clinic"

 

Then Append the data in the Query Editor to your Clients data (so you will append from your Clinic data). In doing so you can have all your data in one table. And then you can use the Classification on the map to show them as different colours.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog
Community Support
Community Support

Re: Labels on Maps

Hi @dibbkd,

 

Has guavaq's solution solve your issue?

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
dibbkd
Frequent Visitor

Re: Labels on Maps

I want one map that shows my clients (a few thousand of them), and also shows my several clinic loations in another color.   I have a mySQL database I'm pulling the client info from, and a separate small table with my clinic locations.  I don't want to have to edit the client table to add my clinic locations each time, and also they contain different information besides the address.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors