Drill down Cartogram map with roadnames?

[FoolzRailer]

Hello

I'm trying to create a drill down Cartogram map with Danish data, that goes from Region-Postal Code-Road Name. But however I do it I can never get it too work with Road Names. Region and Postal Code works just fine, but when I try to move to Road Name it just moves me to New Jersey. 

I've tried different combinations of columns with RoadName, PostalCode, Country and other hierachy combinations, but nothing works. Sometimes it gives me that little I at the top, indicating that more placement information is needed. I can't use coordinates unfortunatly, though that would be easier. 

Sample pbix:

https://1drv.ms/u/s!AlfA0KbCw_8kg9IoQm4LeE8xMb9b0w?e=GjD4Wl

[v-shex-msft · Accepted solution]

HI @FoolzRailer,

AFAIK, current power bi seems not support mapping 'road name' level information. (it works with the common data categories such as Address, City, Continent, Country/Region, County, Postal Code, State or Province, but road not include)

Tips and Tricks for maps (including Bing Maps integration) - Power BI | Microsoft Docs

Perhaps you can consider contacting to power bi custom visual team to report these and help improve the custom visuals.

Power bi custom visual team 
Regards,
Xiaoxin Sheng

[FoolzRailer]

Appreciate your feedback @v-shex-msft. The weird thing is I actually got roads to work in the Map visualisation but not in the Cartogram. Just missing the ability to drill down in the Maps visualisation, as that would have been preferable. 

[v-shex-msft]

Hi @FoolzRailer,

As you said, the map visual can be zoom to the street/road level.

Based on the document that I shared, these types of information not accurate enough to help power bi correct mapping the location of the special points/range. (you can try to combine use other category fields to help power bi mapping records but they may not work correctly if you merged them with other fields as a hierarchy)

Regards,

Xiaoxin Sheng

[FoolzRailer]

Hi @v-shex-msft 

I think you are right that it is not possible. I've already tried different datafield types in combination with different hierachies, and so far they all fail after the Postal Code. I appreciate your help though! Perhaps I should try and suggest it is a feature/feedback improvement.