Forum Discussion
Map displays multiple KPIs
Thank you for your attention. I completed it using a third-party visualization in the end.
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?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)?