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