Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Drill down Cartogram map with roadnames?

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

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI Anonymous,

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Appreciate your feedback Anonymous. 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. 

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Anonymous,

        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