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:
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.
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.
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!