Map displays multiple KPIs

[一棵黄葛树]

Hi,

Assuming there are dealers and stores, how can they be displayed on the map visualization object with different icons at the same time?

[v-priyankata]

Hi @一棵黄葛树 
Thank you for reaching out to the Microsoft Fabric Forum Community.
@kushanNa @amitchandak Thanks for the inputs.

I hope the information shared by users was helpful in meeting your requirements. Based on your last statement, are you still experiencing any issues, or have you found a solution? Please let us know if you need any further assistance we're happy to help.

[v-priyankata]

Hi @一棵黄葛树 

I wanted to check if you had the opportunity to review the information provided by users.  are you still experiencing any issues, or have you found a solution? Please feel free to contact us if you have any further questions.

[一棵黄葛树]

Thank you for your attention. I completed it using a third-party visualization in the end.

[v-priyankata]

Hi @一棵黄葛树 
I'm glad your issue has been resolved. Thank you for letting us know. If you have any further questions or concerns, please feel free to reach out to the community. We're here to help.
Thanks.

[kushanNa]

Hi @一棵黄葛树 

As far as I know, there's no built-in method in Power BI maps to add different icons. So your best option is to go with a custom visual, though there may be pricing or other limitations.

If you prefer to stick with Azure Maps, there is a workaround for this. However, the city name will still be visible alongside the icon.

Please follow the steps below:

create a new icon column 

Icon = 
SWITCH(
    TRUE(),
    'YourTable'[Type] = "Dealer", "🛠️",
    'YourTable'[Type] = "Store", "🏬"
)

and join that icon column with the city 

Join = YourTable[City] &" - "&  YourTable[Icon]

and add that column into the map & mae category labels visible

please find the attached sample pbix file for your reference 

[一棵黄葛树]

Thank you very much, my needs have been basically met. I would like to ask two more questions:
1. My city is not located by name, but by latitude and longitude. How can I rewrite the auxiliary calculation column?
2. Why is dragging the 'Icon' field directly invalid? Do we have to pull the 'Join' field?

[kushanNa]

It seems you can use the latitude and longitude columns, but you’ll need to have a specific unique column with store names or IDs to use as labels along with the icons. Also, you will need to set the latitude and longitude fields to average aggregation.

please find the attached updated pbix file

And to answer your second question — it seems that Power BI needs something to identify the location. So, if you're not using latitude and longitude, the city name must be present; an icon alone won’t work. If you are using latitude and longitude, you still need a unique identifier (like a store name or ID), because using only an icon will create just two groups (based on icon type) and not uniquely identify each location.

[一棵黄葛树]

I sent it to the customer today, and the customer said that this is a tool tip, not a direct display legend on the map. You need to hover the mouse on it to display what it is (store or distribution room)?

[kushanNa]

Sorry, I don't quite get what you mean. Do you mean that what I suggested is being shown to the customer as a tooltip? Or that the customer actually wants a tooltip instead of a direct display?

If it's the second case, you can switch off category lables & you can simply use the tooltip feature — just drag and drop the columns you want to show into the Tooltip section.

[一棵黄葛树]

Anyway, thank you for your patient guidance!
The customer's requirement is for direct prompts, not tool prompts. Assuming a certain coordinate is a store, mark it with a red dot on that coordinate (which can also be satisfied by the native view). Assuming that this coordinate is a dealer (or in other words, there is a dealer at that coordinate), insert a red flag symbol. This makes it easy to see how many stores and distributors are distributed in a certain area? Of course, if there are both stores and distributors at the same coordinate, both the red dot and the red flag need to be displayed simultaneously.
The plan you gave me has dots all over the map, and there is a text prompt box near the dots displaying "unique value&corresponding icon". The client wants to directly place the corresponding icon on the map.

[kushanNa]

Oh okay, like I mentioned in my first comment, your best option would be to use a custom visual—try something like Icon Map. The method I’m suggesting is only a temporary & partial workaround to display the icon, but you won’t be able to interact with it since it’s just a label.

[一棵黄葛树]

Thank you, I used to use scatter plot and map (background image), but the matching effect was not good.

[amitchandak]

@一棵黄葛树 , with Long/lat you can display them on the Azure map. I doubt a different icon, but Azure map provide a few options to play around  

[一棵黄葛树]

Thank you for your answer. It seems that Azure map is not working?
Also, I can't watch Youtube videos here.