Forum Discussion

Frequent Visitor

8 years ago

Solved

Drilldown Choropleth by MSA

Hi there, My goal is create a Choropleth Map shaded by Quintile by MSA. I have Quintile value identified at ZIP and MSA level. However on the map it won't shade all. Please advise. I am ...

Need Help

Tips and Tricks

v-juanli-msft
8 years ago
Hi marlline

According to this article, please check if you have done the correct steps.

To use the visuals, bring a dataset into Power BI, and put the custom visual on your page.

Put your data’s first-level location property in the Locations field, and the property you want to chart in the Values fields.

Then on the visual’s Formatting pane, open the Shape customization and put the URL to the first level of your map in the Level 1 box, the URL to your next level in the Level 2 box, and so on. If the name of the geographic property of your map doesn’t match the name of the field in your data, you can set that property name in the ID boxes.

Reference

http://blog.pragmaticworks.com/power-bi-custom-visuals-drilldown-choropleth

Best Regards

Maggie

v-juanli-msft

Community Support

8 years ago

Hi marlline

According to this article, please check if you have done the correct steps.

To use the visuals, bring a dataset into Power BI, and put the custom visual on your page.

Put your data’s first-level location property in the Locations field, and the property you want to chart in the Values fields.

Then on the visual’s Formatting pane, open the Shape customization and put the URL to the first level of your map in the Level 1 box, the URL to your next level in the Level 2 box, and so on. If the name of the geographic property of your map doesn’t match the name of the field in your data, you can set that property name in the ID boxes.

Reference

http://blog.pragmaticworks.com/power-bi-custom-visuals-drilldown-choropleth

Best Regards

Maggie

marlline

Frequent Visitor

8 years ago

v-juanli-msft

Thank you so much for your reply and I achieved above map. However still 2 questions:

1. How to only show the state boundary. Right now it seems to show county boundaries which make the map look very messy.

2. How to show state name on the map?

Thank you!!

annamalaig
Frequent Visitor
7 years ago
To show only states on the maps -

On the Drilldown Choropleth Map configure Level 1 under the Shape, and remove the level 2 which builds the map at the county level

Shape/Level 1
https://uat.gramener.com/static/c3/US_adm1.json