cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Super User IV
Super User IV

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

Highlighted
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. 

 

Highlighted
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.

Highlighted
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

Highlighted

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!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors