Hi,

first of all great visual!

I'm having an issue with the projection of a map of sweden counties - I want to use Orthograpic but it doesn't look good at all.
The mercator projection is ok, but not perfect.

Anything I'm missing here?

I'm using this one for the counties: https://github.com/deldersveld/topojson/blob/master/countries/sweden/sweden-counties.json

Here is the mercator map:

Here is what I want it to look like (I used the shapemap viz here):

Thanks
Ben

When using the Drill Down Choropleth visual with a Legend, you can set Data Colors in the normal manner. However (unlike most visuals) these dont "stick" - every time the visual is filtered it re-assigns colors from the default palette.

You can repro this behaviour using the sample PBIX file provided with the visual. From the page: Choropleth with Legend, go to the Visual Level Filters and filter the Party field, e.g. select B and D. You can also try using the Format / Data Colors property to set a specific color, then change the filter and watch it reset to the default palette.

For my scenario, each value in the Legend field should show in a specific colour, regardless of filtering. This is achievable with other visuals e.g. TreeMap. Please fix this aspect of an otherwise outstanding Custom Visual.

When I add state_name and county_name in this order to the location role everything works just fine, when I add them in the opposite order however I add county_name below state_name, the display is ruined.

Normal:

With added in wrong order:

And if I drill down 1 level to the county level (with fields added in the wrong order):

I think the reason for this issue is the same as for #19

cc. @uve

with the sample file downloaded from Mircosoft Application Store,
this error will emerge itself.
For any Topojson file I used, the bug can't be fixed.
Seems the problem has been persisting for a long moment from the comment area of the application.
https://appsource.microsoft.com/en-US/product/power-bi-visuals/WA104381044?tab=DetailsAndSupport

This is a great visual but what would make it even better would be if you can have map options as the background for the visual under data.

Is there a way to use SSAS dimension attributes which have key and named columns defined?

The Drill Down Choropleth only works, when a key column is defined for a dimension attribute. When you add a named column the choropleth can't visualize the data.

It seems that there is a conflict between the key and the name attribute. The data is bounded to the key property. But the choropleth works with the name property.

I am trying to use this app to drill down to the county level but it seems this has issues displaying certain states. This is what it looks like before I click on a state I want to drilldown to.

Some states do work. Ex. California

But others are completely messed up. ex. Texas

or washington

This tool would be great if all states worked.

This is a great visual that we are just starting to explore. Thanks for creating it.

We are currently prototyping it to drill down from a country level (Canada) to a province, to a very detailed municipal level. So there are 3 drilldown levels altogether.

We are running into an issue with scaling of the most detailed level. It appears that the control is limited to approximately 9 zoom levels. While this may seen like a lot it results in many municipalities zoomable to a max of approximately 10-20% of the visualization's surface area.

Is it possible to increase the maximum area so the user has an option to fill 100% of the visualization's surface?

Is this visualization/repo still maintained or can it be considered discontinued? If it's still active, when is the next version coming out? Thanks.

Can we please have extra validation to ensure this value falls between between Min and Max? It's currently very easy to accidentally misconfigure during report authoring.

I've created a simple test example using 2 TopoJSON files (zip attached). The one with a single attribute works fine. The one with multiple attributes does not work - the visual seems confused about which one to use. It seems to ignore whatever is specified for the ID field, and just scan the properties looking for matches?

I realise my multi ID properties data is nonsense/unlikely, but I actually stumbled across this issue using numeric IDs. So "1" from one property was being confused with "1" from another.

If I've misunderstood how this should be handled, then please let me know how to fix it.

Drilldown Choropleth issue - IDs are ignored.zip

Hello,

I have spent countless hours working to make this visualization work for me. I am pretty close to getting it to do what I need it to do, but do not know where to go from here. I will explain my process and I hope that somebody can help me troubleshoot.

I am trying to use the IRS business master file to count the number of nonprofit organizations in my state by county, then zip. I am currently able to toggle between the two levels (county and zip), but I am not able to use the drilldown function to click on a county and have it zoom in to the zip codes of that county only (a function that works intermittently in the US drilldown example provided). For example, Oklahoma only shows one county when one uses the drilldown feature in the Power Bi example doc, but Florida shows all counties.

Eventually I will be doing this with national data as well. So I will need to drilldown three levels - State, County, and Zip code.

This is what I have done so far.
I started by downloading a county TopoJson Files from https://github.com/deldersveld/topojson/tree/master/countries/us-states

I then needed a zip code level so I downloaded a map file from: https://okmaps.org/ogi/search.aspx in WGS84 Lat/Long format and uploaded them into MapShaper. From there I generated the TopoJSON file and uploaded to a GitHub Repository. This allowed me to toggle levels, but I cannot use the drilldown feature with good results.

Sidenote: I have also used okmaps and mapshaper to create a county map to use, but the one from GitHub I used worked better.

These are some of my ideas as to why it is not working:

• I noticed that the India example in the provided PowerBi file has greatly simplified the lines of the map. I am curious if perhaps I need to reduce the file size for it to properly render in PowerBI.
• I noticed that in example document, the raw view of the TopoJSON files Include the hierarchy on levels within the code in the properties. (Country, state, third level) When I generate maps with mutiple layers in mapshaper it does not include the hierarchy within the properties. It essentially layers the code one after the other. I am wondering the the hierarchy has to be written into the properties or if I can use single layer maps. Example, i would like to just have one county level map for level 1 and one zip code level map for layer 2 - but it seems the layers may need to be written into the code. I hope this is not the case.
• My column names are not named the same as in the properties of the TopoJSON file. Do I need to rename the columns of the data set to reflect whatever is the the properties of the TopoJSON file?

Please help! I really want to use this visualization, but it has been very difficult to figure out.

Thank you
Trent Brewer

When I add a field (county_name) that is used for drilldown to the legend role, the display is completely ruined.

Normal display without legend:

The same data, the same settings with county_name added to legend

Looking at the code it seems to me that the issue comes from the way the plugin calculates which drilldown level we are currently at (curr_level in the code).

@uve Is there a better way to determine the current level of drilldown?

cc. @ryanbaumann

Hi ,

are there any option to define the colors based on the legend(conditional formatting), at the moment, colors cannot be fixed based on the legend values

Thanks in Advance

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

Hi, I'm struggling to get this visual working in PBI. I've got good topojson files that I use in the preview shape map visual but keep getting 'Invalid json' error in Desktop.

I've tried downloading the source files with a view to investigate but I can't start it.

Errors.....
error Could not find source file: '.api/v1.7.0/PowerBI-visuals.d.ts'.
error undefined
error ENOENT: no such file or directory, open 'C:\Users\me\Documents\Power BI custom
visuals\powerbi-visuals-drilldown-choropleth-master.tmp\build\visual.js.map'

Thanks

Can we please have some guidance on the security requirements around these URLs? For example, do the URLs need to be publicly available? Or are credentials passed from PBI to the URLs to facilitate authentication (and if so, how)?

Would it be possible to introduce the possibility of using a tooltip page in the visual?
The visual is fantastic I use it in several of my projects
https://github.com/FMullor/Argelian-drilldown-choropleth-maps

Can the visual please be extended to allow it to be used with maps embedded into the .pbix file (i.e. same as Shape Map visualization)? The requirement to host maps at a URL is a barrier to usage.

Hello,
I am using this file : https://raw.githubusercontent.com/gaful/francegeodata/master/contour_departement.json for maps.
When I want to map data at level 1 and enter insee_dep value, the chloropeth map it with insee_reg field instead. I am not sure if the issue is because they both start with the same string, but it seems a plausible source.

Thanks for your help
Regards
G

The values that are showing when you hover over the map ignore the formatting of the measure or column. It would be great if you values would use the formatting set for the measure/column.

After importing a GEOJSON custom map file into GitHub and exporting a TOTOJSON file into Power BI, the map does not display correctly as the entire map is considered one region, and only a different region is bolded (all though the others are grayed out).

The GEOJSON file in GitHub looks perfect, so I did not expect any issues after that point. Is there something else that could be driving this?

Is it possible to open up the color customization capability so the color ranges can be tweaked independently for each level?

The colors that are ideal at a high level are often not the best ones for a lower level. This is especially true if all 3 levels are used in this visualization.

The visuals in sample.pbix show "invalid JSON file". By the way, this repo doesn't have the latest release (version on AppSource is 1.0.2).

Following issues have been noted in Drilldown Choropleth Chart, Please advise if there are any solutions

1. I would like to predefine data colors based on Legend

2. once we go to last drilldown(lets Say - Country,Province,District), when i select District, map gets zoomed in , but the district does not get selected

3.values shown in the tooltip are not formatted(value shown as 2464645 instead 2,464,645) due to the issue percentage values cannot be used in legend, we will have to multiple by 100

4.Data labels option is not available in the map