Forum Discussion
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?
Thank you for your attention. I completed it using a third-party visualization in the end.
14 Replies
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.
一棵黄葛树 , 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.
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.
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.
