Drilldown on a map based on a custom grouping of countries

[cverive]

Hello,

Hopefully someone can help or at least let me know if this is impossible to do... Is there a visualization in PowerBI that allows you to drilldown on a map based on your own customized grouping?

For example, I have US (with $1M in revenue) and Canada (with $2M in revenue) together as "US&CAN". I want to show a consolidated bubble over US and Canada on the map showing $3M in revenue for "US&CAN". Then can I drilldown on that $3M bubble and it will split into 2 (1 over Canada with bubble showing $2M and another 1 over US with a smaller bubble showing $1M)?

Appreciate any help!

[ChrisMendoza]

@cverive -

Have you looked into https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks#use-geo-hierarchies-s...?

[ChrisMendoza]

@cverive -

I wonder if some creative genius could be made using the pattern found at https://www.daxpatterns.com/parent-child-hierarchies/? I feel like it could work.

[cverive]

I'm not sure how that could help and apply to a map visual where you can drill up to a custom group of countries that aren't exactly on a world map e.g. "Andean Region" being made up of Colombia and Ecuador...