Use fillmap to highlight EU and UK

[relinavas]

I'm working on a fillmap visualization to display countries in the EU and the UK. I've created a separate table with two columns: one listing the countries and the other assigning them as either EU or UK. However, linking these tables caused issues, and the fillmap stopped displaying any countries.

Another option I’m considering is modifying the existing dataset by manually replacing the rows for EU and UK with their member states, but this seems quite tedious. Is there a more efficient way to approach this problem?

[Anonymous]

Hi @ relinavas,

In testing no issues were encountered where the fill map stopped displaying countries.

Based on the data you provide, the countries can be displayed normally on the fill map.

The relationship between the two tables is shown below.

Please check if this option is enabled and re-open the PBIX file after enabling it.

Best Regards,

Dengliang Li

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

[relinavas]

Hi @Anonymous ,

I noticed you used the "EU&UK" table for the fillmap visualization. However, I need to show the countries and data linked to it from the "Consolidated" table. Please let me know if there's a workaround.

Thank you for your help!

[Anonymous]

Hi @relinavas ,

I'm afraid there is no better way than to replace EU in the Consolidated table with its member countries.

This is because the location EU does not exist in the Fill Map.

Best Regards,

Dengliang Li

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