Forum Discussion
Drilldown Choropleth State/County Errors
The issue was corrected by using State Fips codes instead of the state name
Community SupportHi Anonymous ,
Drill requires a visualization with a hierarchy, for more details, see the article https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill. So please check if a hierarchy exists in the above fields.
In addition, you need to click these icons to implement drill down and drill up instead of clicking the data point.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-xicai, I have already done these steps and still am having an error. I am using a Drilldown Choropleth map that was input from the marketplace.Clicking the "Go to the next level in the hierarchy" button it works fine and represents the data I want. The issue I am having is when I click the "Drill Mode" button. ( See below for "Show data"). Maybe I am understanding the hierarchy wrong?
I have now added an offical hierachy(State and FIPS#), but still having the same issue. I think my issues might lie in the dealer(in the legand). When I click on a State(Texas for the example above). Only the Peak Trailer Groups data shows, which is the leading dealer(but not the only) in that state so that is the color that comes up at the state level.
The issue was corrected by using State Fips codes instead of the state name