Forum Discussion

bbbbi01's avatar
bbbbi01
Icon for Helper II rankHelper II
2 years ago
Solved

Drilldown choropleth map display no data

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 ...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • bbbbi01's avatar
    bbbbi01
    2 years ago

    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!

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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_adm1.json

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

 

3.The result is shown below.

 

 

Best Regards,

Wisdom Wu

 

 

 

  • bbbbi01's avatar
    bbbbi01
    Icon for Helper II rankHelper II
    2 years ago

    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!