Forum Discussion
Helper IIDrilldown 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 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:
Can someone help me regarding this.
Thanks in advance.
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!
2 Replies
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.
3.The result is shown below.
Best Regards,
Wisdom Wu
bbbbi01Thank 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!
