Document choropleth options

[otravers]

Can you please post examples of valid values for Source Layer Name and Vector Property like is already done for Vector Tile URL? How do you find out these values, for, say: mapbox://mapbox.us_census_states_2015?

[pedro-rtm]

I have the same question. Great visual by the way, thanks!

---

From: Olivier Travers notifications@github.com Sent: Thursday, February 22, 2018 7:43:15 AM To: mapbox/mapboxgl-powerbi Cc: Subscribed Subject: [mapbox/mapboxgl-powerbi] Document choropleth options (#68)

Can you please post examples of valid values for Source Layer Name and Vector Property like is already done for Vector Tile URL? How do you find out these values, for, say: mapbox://mapbox.us_census_states_2015?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://github.com/mapbox/mapboxgl-powerbi/issues/68, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AcyHqrVfyEkQuU7z_hezMzuD58TY-qyZks5tXW7zgaJpZM4SPVQE.

[ryanbaumann]

@otravers @PedroRiveraTorresMoir thanks for the feedback!

The choropleth visualization layer is an enterprise feature of the Mapbox Visual for Power BI. You can create any custom shapes from shapefiles, geojson, or KML files using Mapbox Studio and use them in Power BI. You can also integrate the Mapbox Visual with our Enterprise Boundaries product, to access curated administrative and postal boundaries globally in your Power BI dashboards.

If you want to try an evaluation version, please reach out to our Enterprise team.

I'll leave this ticket open until we publish examples and documentation of the Enterprise features of the Mapbox Visual for Power BI, including using the Choropleth layer with Enterprise Boundaries.

[pedro-rtm]

Very cool, thanks for the info.

Already in contact with DJ for a quote for enterprise boundaries extensibility.

Best wishes

From: Ryan Baumann Sent: Friday, February 23, 2018 3:15 PM To: mapbox/mapboxgl-powerbi Cc: Pedro Rivera Torres Moir; Mention Subject: Re: [mapbox/mapboxgl-powerbi] Document choropleth options (#68)

@otravers @PedroRiveraTorresMoir thanks for the feedback! The choropleth visualization layer is an enterprise feature of the Mapbox Visual for Power BI. You can create any custom shapes from shapefiles, geojson, or KML files using Mapbox Studio and use them in Power BI. You can also integrate the Mapbox Visual with our Enterprise Boundaries product, to access curated administrative and postal boundaries globally.

If you want to try an evaluation version, please reach out to our Enterprise team. I plan to publish more examples of Enterprise features using the Choropleth layer with Enterprise Boundaries soon so you can try interactive examples. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.

[otravers]

@ryanbaumann thanks for clarifying. It's a shame this functionality will be gated behind Enterprise vs. ESRI's choice to price their Plus Power BI visual at $5/user.

What about 3D, do you plan to expose fill-extrusion as a visual property where a DAX measure could be dragged? I have things like this in mind: https://ubilabs.net/en/news/3d-map-visualizations-with-mapbox-gl-js-2016-12-19

In early versions of your custom visual, your base dark theme was in 3D (it looked like Klotantech 3D), do you plan to put that back?

[ryanbaumann]

@otravers this is valuable feedback re: choropleth visualization layers gated behind Enterprise. Let me talk to the team on Monday and see if it makes sense to open up the Choropleth layer for all users.

What about 3D, do you plan to expose fill-extrusion as a visual property where a DAX measure could be dragged?

That's a great feature request we could incorporate into a future version - could you open a separate ticket for that? As a follow-up question, would you want the fill-extrusion layer to be for boundaries (similar to a choropleth), or for more of a density / hexbin style map?

In early versions of your custom visual, your base dark theme was in 3D (it looked like Klotantech 3D), do you plan to put that back?

The 3D portion of the Mapbox Power BI example visual was created using a custom style. That capability is natively in the Mapbox Visual for Power BI today 🎉 .

You can add any layers including custom hillshades, fills, symbols, circles, lines, and fill-extrusions, and drop them into your viz in Power BI as a custom style from your Mapbox account using Studio.

Here's an example using a custom style I created in Studio with a fill extrusion layer for building and a terrain hillshade layer.

https://app.powerbi.com/view?r=eyJrIjoiZGM4OTJmMGQtY2Q5MS00MTgzLWFiOTAtOTUzNjRkOTY4MGJiIiwidCI6IjYyOWE3MGIyLTMyYjktNDEyNi05NTFlLTE3NjA0Y2Y0NTZlYyIsImMiOjF9

[otravers]

The 3D portion of the Mapbox Power BI example visual was created using a custom style. That capability is natively in the Mapbox Visual for Power BI today

Right. I did try importing the following 3D style into Mapbox Studio but it didn't work for me. Anyway that's not a Power BI issue, I'll try again later. https://github.com/openmaptiles/klokantech-3d-gl-style

You can also integrate the Mapbox Visual with our Enterprise Boundaries product, to access curated administrative and postal boundaries globally.

I was not aware you had these boundaries, that's very cool. But again this wouldn't work for the small/medium businesses I typically consult for. I can easily get them to spend $10/mo for selected executives and power users that will use Power BI. If I build a convincing BI GIS demo for them, I can also get them to spend $5/mo for a few ArcGIS Plus subscriptions on top of PBI. But we won't have a business case to license an enterprise mapping solution that would cost them much more than the core host BI platform. For a specific use case I'm working on, we're looking at Local Government Areas in Greater Melbourne for trade area analysis. I can see that you have them, while ArcGIS Plus in PBI doesn't (yet). But this would be a potential $10/mo customer, not a 5/6 figures a year Enterprise license!

Anyway, I've drifted off topic into a business model discussion, and to what extent you choose to align with Power BI's mass market model (start free, add Pro users at $10/mo) is obviously your choice. Thank you for your responsiveness and detailed answers!

[ryanbaumann]

@otravers

Right. I did try importing the following 3D style into Mapbox Studio but it didn't work for me. https://github.com/openmaptiles/klokantech-3d-gl-style

That's because the tiles in that style are hosted on a 3rd party URL: https://free.tilehosting.com/data/v3.json?key={key}. Studio only accepts sources hosted on your Mapbox account to keep styles optimized and fast to serve (you can upload any data to your Mapbox account to style in Studio). 3D building data is already included in Mapbox Streets - you can simply change the building layer from any Mapbox default style to a fill-extrusion layer to try it out. Here's an example of the settings to hit in a style to add 3D buildings - https://www.mapbox.com/mapbox-gl-js/example/3d-buildings/

Anyway, I've drifted off topic into a business model discussion, and to what extent you choose to align with Power BI's mass market model (start free, add Pro users at $10/mo) is obviously your choice.

No, thank you for your detailed use and business case! This helps us really understand what you and your customer need.

[otravers]

3D building data is already included in Mapbox Streets - you can simply change the building layer from any Mapbox default style to a fill-extrusion layer to try it out

Success!

I struggled a little bit in Mapbox Studio, finally got Height to work with fill extrusion by editing the property as JSON and using type: identity (StackOverflow FTW). I see that this works internationally too, wow...

Now, if I wanted both building color (to circle back to the choropleth topic) and height to be data-driven, I guess I'd need to create two layers in Studio, and load the data there... Related links:

• https://www.mapbox.com/help/how-map-design-works/#data-driven-styles
• https://blog.mapbox.com/visualizing-an-entire-citys-buildings-live-with-runtime-styling-453fe7e39ae6

[ryanbaumann]

🙌 @otravers! Yeah, the best way to do identity functions for now in Studio is to hand-edit the style JSON as per https://www.mapbox.com/mapbox-gl-js/example/3d-buildings/.

Now, if I wanted both building color (to circle back to the choropleth topic) and height to be data-driven, I guess I'd need to create two layers in Studio, and load the data there... Related links:

You can create any number of data-driven style properties in one layer - you could easily style building height based on color, for example like this.

I think what you're asking is how you'd join your data from Power BI (for example, data of store locations) to 3D buildings, and change the color of the building based on that. Correct?

[otravers]

You can create any number of data-driven style properties in one layer - you could easily style building height based on color, for example like this.

Thanks, I was confused by the Studio UI but you got me to try again and I found how to set data sources for each property (I was clicking in the wrong place). Here, I have color-coded 3D buildings based on their OpenStreetMaps tagging:

I think what you're asking is how you'd join your data from Power BI (for example, data of store locations) to 3D buildings, and change the color of the building based on that. Correct?

Yes, that's the ideal architecture, I guess like in the following example but with PBI being both the cross-filtering client and the data source: https://www.mapbox.com/labs/dataset-join/#3.25/38.59/-97.38

That said I still plan to test uploading data to Mapbox Studio.

I really derailed this issue off its original topic, but this was very helpful!

[ryanbaumann]

Great! The 3D feature request would be resolved by https://github.com/mapbox/mapboxgl-powerbi/issues/70. Lets move any use case detail to that issue.

[VitalyMCT]

@ryanbaumann , are there any other features within the current visualization that require an Enterprise license?

Would it be possible to somehow separate the Enterprise features from the baseline ones for clarity? Perhaps this can be done by publishing two versions of the control, selectively enabling the features (similarly to how Esri does it with the Plus subscription button), label prefix/suffix, tooltips, or any other mechanisms available within the Power BI custom visuals platform?

[ryanbaumann]

Great feedback. @vitaly-livshits I'll open a new ticket to add clarification and documentation of what's available in the free version versus enterprise.

[VitalyMCT]

@ryanbaumann, thanks, looking forward to referencing that.

I agree with @otravers 's comments around choropleth pricing and would like to add that this is also important for deployments at large organizations. In such deployments we need to prove success of choropleth on a small scale (single digit user counts) before scaling up to 250+ users on Enterprise (if ever). Without a custom demo/PoC/smaller-scale pilot it will be almost impossible to convince our stakeholders to buy into Enterprise. I am hoping the Mapbox for Power BI pricing structure can be made more flexible to allow for such use cases.

[ryanbaumann]

An excellent business case, @vitaly-livshits. We'll take your feedback into factor as we push what to open up next!

[ryanbaumann]

Working on a beta version of choropleth layers from any Mapbox Vector Tille source here -> https://github.com/mapbox/mapboxgl-powerbi/pull/76. Still WIP.

[ryanbaumann]

Consolidating all of the Choropleth tickets into one master ticket we're working here https://github.com/mapbox/mapboxgl-powerbi/issues/80