Forum Discussion
ArcGIS Maps for Power BI (Preview) Discussion
scottball any update on when the Australian ASGS boundaries are going to get looked at. Also any idea on when the visual will be avaliable in Power BI Embeded. We want to use the Esri Visual and Power BI Embeded for a 2016 Census data project in July but these two issues are major obsticals at this stage. Thanks
Hi,
First of all let me say I am very enthousiastic about the added functionality of ArcGIS in PowerBI! It greatly enhances the value of PBI for me.
I am using it intensively for supply chain planning and have some suggestions for improvement. My wishlist for future improvements in order of priority:
- In a size and categorical color mode, when multiple catagories share one location it would be essential for me to show values in a pie chart (currently the circles are drawn on top of each other). The total size of the pie chart should match with the total volume of all overlapping categories, which is actually what the existing map funtion in PowerBI already has.
- Adjust the size based on what is selected. Currently the size is only reset when going to edit mode and adjusting the size slider, so filtering values on a page can make the bubble size very small.
- Option to permanently display tool tips/labels on the map
- Disable the auto zoom feature
- Current size sttings (equal interval, natural breaks) do not seem to be proportional to the value behind it. Small values are still relatively large circles on the map. I would like to set the bubble size area or the bubble size diameter equal to the quantity.
- Add a legend for color coding used (both categorical as well as continuous color scheme)
- Expand the colors of the pin locations, to better match a company color scheme.
- Ideally, I would like to map a network using from- and to- locations, with arrows/lines in between. But I can imagine this is a bridge too far.
I am looking forward to the formal release, please let me know which of these suggestions can be taken into account!
Best regards
Michiel
scottball: Thanks for your message. Good to hear that you are seriously taking the suggestions into consideration!
Regarding your remark on the clustering function: This is a little bit what I'm aiming for, since it involves the pie charts with category colors. What I miss is:
- The clustering view radius has a minimum of 5 px, so it will cluster locations which are near to each other. It would be good to have the option to lower this radius so that it only clusters categories which overlap on exactly the same location.
- The pie segments should be proportional to the quantity of each category. Now they are divided equally.
- The size of the total pie should represent the total quantity. Preferrably be equal to the size of another location with the same (total) quantity.
Note that this functionality is exactly equal to what the built-in map visual of PBI provides. Also the custom visual "flow map" contains a similar feature. Because the Esri visual is much better in many other respects, I would really appreciate if it can be included.
Looking forward to your reply, feel free to contact me directly to exchange more details.
Michiel
mwschepers - thank you for using the visual and providing some really great feedback around what you'd like to see in the future. As I'm sure you've noticed, we iterate quickly and roll out new functionality and bug fixes nearly monthly. We will evaluate your enhancement requests and determine which can be incorporated into our near term and long term roadmap. As we dig into these issues we may need to reach out to more clearly understand your use case.
One thing I did want to mention, regarding your highest priority - are you aware that you can get pie charts when using categorical data right now? It's a part of clustering. Take a look at this gif and let me know how close it is to what you're looking for: http://imgur.com/trpY69E
I woudl second the ideas that mwschepers has put forward. Some of these are very much in line with some of our requests for a map legend and some of the other features. The pie charts working in line with the Microsoft mpping visual would certainly also be our preference. Also the drill down ability that the Microsoft visuals have would also be highly desirable. This should be able to be achieved with changes the Microsoft are making so hopefully this will feed through to the Esri visual.
