Drilldown choropleth map display no data

[bbbbi01]

Hello All,

I have been trying to create drill down choropleth map with heirarchy state and county. I have taken links and provided in level1 and level2 fields in formatting pane. When I hover on the first picture i can see data of these states. But when i clicked that state, it is displaying as no data. These are the url used:

https://raw.githubusercontent.com/SavithriBoda/topojson/master/countries/united-states/us-albers.jso...

https://raw.githubusercontent.com/SavithriBoda/topojson/master/countries/united-states/us-albers-cou...

Can someone help me regarding this.

Thanks in advance.

[Anonymous]

Hi @bbbbi01 ,

If I understand correctly, the issue is that you couldn’t display no data when drilldown choropleth map. Please try the following methods and check if they can solve your problem:

1.Ensure that the data model includes both state(Name1) and country(Name2) level data.

2.Check that the shape level1 and level2 is correct.

Level1: https://raw.githubusercontent.com/microsoft/powerbi-visuals-drilldown-choropleth/master/TopoJSON/US_...

Level2: https://raw.githubusercontent.com/microsoft/powerbi-visuals-drilldown-choropleth/master/TopoJSON/US_...

3.The result is shown below.

Best Regards,

Wisdom Wu

[bbbbi01 · Accepted solution]

Thank you for your inputs! I have the two level data(state and county),so when i hovered texas, it showed the data of texas. But when i clicked it, it showed the counties but no data. I tried to use your links, but it couldn't show counties. I thought the reason is that power bi couldn't recognize my county names, so i used FIPS. Finally it worked. When i drilled down, it showed specific counties with data. Just for sharing. I appreciate your help!