cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Defining regions for mapping

In their data entry forms, users can select either a single country or a region consisting of multiple countries (e.g. Scandinavia = Denmark, Norway, Sweden). The values in the Location column therefore include both countries and regions. For example, in a dataset with only 5 records the Location column might contain these values:

 

Norway
Sweden
Sweden
Scandinavia
Denmark

 

In PowerBI, if the record for Scandinavia is selected, I want the map to fill all three countries.

 

Is this possible by grouping? Or can I define a region and relate that to the Location column (sounds unlikely to me)?

 

The map is based on an imported shape file, so not Bing or Esri.

 

Many thanks for any advice!

 

5 REPLIES 5
Helper I
Helper I

Thank you all for your advice - it is very helpful. I am continuing to work with this and will post a conclusion if I find a solution.

Community Support
Community Support

Hi @CJDK 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

 

Best Regards,

Rico Zhou

Hi @RicoZhou  - I am still working with this and at present have a technical problem with Power BI Desktop. I will return to this as soon as I have finalized my problems, but in the meantime I cannot say this is a solution. Thanks again for your support!

Community Support
Community Support

Hi @CJDK 

I think you have to transform your data model as below and build a hierachy slicer to achieve your goal.

1.png

Result:

2.png

3.png

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

 

Super User II
Super User II

Hi @CJDK ,

 

can you provide a sample file?

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors