How to use US ShapeMap to display division, region, and state level information based on selection

[Anonymous]

Hi,

I am fairly new to powerbi, just want support from the expert user's if someone has been able to use US Shape Map file from visualization to be filtered on the basis of slicer of division, region, statelevel and provide tooltip(sales value) and color categorization on the basis of selection among these 3.

Any help will be appreciated.

[Anonymous]

Hi, @Anonymous 

May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

If it is not resolved, I hope you will provide the full .pbix file via OneDrive or SharePoint. Please be careful to remove all sensitive information and we will do our best to provide ideas for your issue.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[danextian]

You will need a shapemap file (in topojson format) that has such granularity and import that as a custom map - https://learn.microsoft.com/en-us/power-bi/visuals/desktop-shape-map

There are free shapemaps available at gadm.org but needs to be converted to topojson which free converters are available online. I'm unshure though whether the free ones have the granularity you need.

Note: the more granular a shapemap file is, the longer it is to render and possibly might not at all due to not having enough memory.

[lbendlin]

What's a division or a region?  Do you mean counties/parishes?

[Anonymous]

Thank you for your prompt reply.

States are rolled up to create division which are further rolled up to create region.

https://github.com/cphalpert/census-regions/blob/master/us%20census%20bureau%20regions%20and%20divis...

[lbendlin]

Add the table you referenced as a dimension table to your data model.  If you want to show regions and divisions as shapes then add these attributes to a shapemap file that has state granularity.