Why isn't a country showing on my map visual?

[Sal_Brown51]

I am looking at Countries in the African Region. I have made sure that the country names align with Power BI. all of the countries are fine apart from DR Congo. I've tried it as Democratic Republic of the Congo and it doesn't like that either! Any thoughts? 

[Sal_Brown51 · Accepted solution]

So, after 2 days of head scratching, it now works! I can confim that the Democratic Republic of the Congo DOES exist, because my report says so. For reference, not sure how much difference it makes, but DR Congo is what I've gone with. It appeared the issue may have been something in the Options/Settings section. However, I'm not sure what as I ticked and unticked a few things. BUT! I think it was to do with clearing the cache in the Data Cache Management Options. Thank you all for your help, particularly @SamWiseOwl for persevering! 🎉

  

[SamWiseOwl]

Wohooo victory!

[SamWiseOwl]

Sadly it works on my end.

I am completely at a loss.

Try in a new Power BI file?

Publish to Power BI Service see if it's missing there?

Pretend that country doesn't exist 🤷

[Sal_Brown51]

Thank you all! @v-cgao-msft @SamWiseOwl @darkniqht Still struggling to find a solution... 😞

The map links to data, see the filters with 144 next to them. It’s picking up Year (12 rows) Age Groupings (4 rows) Metric (3 rows) = 144 Nigeria isn’t in the dataset, so that’s fine.

Could it be something to do with that?

I have tried a new map on a new page.

I have tried:

Congo (DRC) 

Congo, Democratic Republic of

Democratic Republic of the Congo

DR Congo

Congo

DRC

[SamWiseOwl]

Can you provide the dataset or a cut down version?

[Sal_Brown51]

Country	Domicile Region	Income Type	Country Code	Year	Age Groupings	Metric	Rate	Decile	Average_Rate_Per_Country
Burkina Faso	African	Low income	BFA	2011	0-14 years	HIV Incidence	0.32	1	0.41
Burkina Faso	African	Low income	BFA	2012	0-14 years	HIV Incidence	0.29	1	0.41
Burkina Faso	African	Low income	BFA	2013	0-14 years	HIV Incidence	0.27	1	0.41
Burkina Faso	African	Low income	BFA	2014	0-14 years	HIV Incidence	0.21	1	0.41
Burkina Faso	African	Low income	BFA	2015	0-14 years	HIV Incidence	0.25	1	0.41
Burkina Faso	African	Low income	BFA	2016	0-14 years	HIV Incidence	0.21	1	0.41
Burkina Faso	African	Low income	BFA	2017	0-14 years	HIV Incidence	0.18	1	0.41
Burkina Faso	African	Low income	BFA	2018	0-14 years	HIV Incidence	0.16	1	0.41
Burkina Faso	African	Low income	BFA	2019	0-14 years	HIV Incidence	0.13	1	0.41
Burkina Faso	African	Low income	BFA	2020	0-14 years	HIV Incidence	0.11	1	0.41
Burkina Faso	African	Low income	BFA	2021	0-14 years	HIV Incidence	0.09	1	0.41
Burkina Faso	African	Low income	BFA	2022	0-14 years	HIV Incidence	0.08	1	0.41
Burundi	African	Low income	BDI	2011	0-14 years	HIV Incidence	0.42	2	0.54
Burundi	African	Low income	BDI	2012	0-14 years	HIV Incidence	0.37	2	0.54
Burundi	African	Low income	BDI	2013	0-14 years	HIV Incidence	0.32	2	0.54
Burundi	African	Low income	BDI	2014	0-14 years	HIV Incidence	0.27	2	0.54
Burundi	African	Low income	BDI	2015	0-14 years	HIV Incidence	0.23	2	0.54
Burundi	African	Low income	BDI	2016	0-14 years	HIV Incidence	0.17	2	0.54
Burundi	African	Low income	BDI	2017	0-14 years	HIV Incidence	0.17	2	0.54
Burundi	African	Low income	BDI	2018	0-14 years	HIV Incidence	0.17	2	0.54
Burundi	African	Low income	BDI	2019	0-14 years	HIV Incidence	0.17	2	0.54
Burundi	African	Low income	BDI	2020	0-14 years	HIV Incidence	0.06	2	0.54
Burundi	African	Low income	BDI	2021	0-14 years	HIV Incidence	0.06	2	0.54
Burundi	African	Low income	BDI	2022	0-14 years	HIV Incidence	0.08	2	0.54
Central African Republic	African	Low income	CAF	2011	0-14 years	HIV Incidence	1.00	6	2.59
Central African Republic	African	Low income	CAF	2012	0-14 years	HIV Incidence	0.92	6	2.59
Central African Republic	African	Low income	CAF	2013	0-14 years	HIV Incidence	0.98	6	2.59
Central African Republic	African	Low income	CAF	2014	0-14 years	HIV Incidence	0.81	6	2.59
Central African Republic	African	Low income	CAF	2015	0-14 years	HIV Incidence	0.69	6	2.59
Central African Republic	African	Low income	CAF	2016	0-14 years	HIV Incidence	0.65	6	2.59
Central African Republic	African	Low income	CAF	2017	0-14 years	HIV Incidence	0.73	6	2.59
Central African Republic	African	Low income	CAF	2018	0-14 years	HIV Incidence	0.70	6	2.59
Central African Republic	African	Low income	CAF	2019	0-14 years	HIV Incidence	0.63	6	2.59
Central African Republic	African	Low income	CAF	2020	0-14 years	HIV Incidence	0.66	6	2.59
Central African Republic	African	Low income	CAF	2021	0-14 years	HIV Incidence	0.66	6	2.59
Central African Republic	African	Low income	CAF	2022	0-14 years	HIV Incidence	0.70	6	2.59
Chad	African	Low income	TCD	2011	0-14 years	HIV Incidence	0.46	2	0.63
Chad	African	Low income	TCD	2012	0-14 years	HIV Incidence	0.42	2	0.63
Chad	African	Low income	TCD	2013	0-14 years	HIV Incidence	0.34	2	0.63
Chad	African	Low income	TCD	2014	0-14 years	HIV Incidence	0.26	2	0.63
Chad	African	Low income	TCD	2015	0-14 years	HIV Incidence	0.32	2	0.63
Chad	African	Low income	TCD	2016	0-14 years	HIV Incidence	0.31	2	0.63
Chad	African	Low income	TCD	2017	0-14 years	HIV Incidence	0.28	2	0.63
Chad	African	Low income	TCD	2018	0-14 years	HIV Incidence	0.24	2	0.63
Chad	African	Low income	TCD	2019	0-14 years	HIV Incidence	0.21	2	0.63
Chad	African	Low income	TCD	2020	0-14 years	HIV Incidence	0.20	2	0.63
Chad	African	Low income	TCD	2021	0-14 years	HIV Incidence	0.18	2	0.63
Chad	African	Low income	TCD	2022	0-14 years	HIV Incidence	0.19	2	0.63
DR Congo	African	Low income	COD	2011	0-14 years	HIV Incidence	0.32	1	0.44
DR Congo	African	Low income	COD	2012	0-14 years	HIV Incidence	0.31	1	0.44
DR Congo	African	Low income	COD	2013	0-14 years	HIV Incidence	0.28	1	0.44
DR Congo	African	Low income	COD	2014	0-14 years	HIV Incidence	0.26	1	0.44
DR Congo	African	Low income	COD	2015	0-14 years	HIV Incidence	0.20	1	0.44
DR Congo	African	Low income	COD	2016	0-14 years	HIV Incidence	0.16	1	0.44
DR Congo	African	Low income	COD	2017	0-14 years	HIV Incidence	0.16	1	0.44
DR Congo	African	Low income	COD	2018	0-14 years	HIV Incidence	0.17	1	0.44
DR Congo	African	Low income	COD	2019	0-14 years	HIV Incidence	0.14	1	0.44
DR Congo	African	Low income	COD	2020	0-14 years	HIV Incidence	0.14	1	0.44
DR Congo	African	Low income	COD	2021	0-14 years	HIV Incidence	0.14	1	0.44
DR Congo	African	Low income	COD	2022	0-14 years	HIV Incidence	0.13	1	0.44
Eritrea	African	Low income	ERI	2011	0-14 years	HIV Incidence	0.07	1	0.29
Eritrea	African	Low income	ERI	2012	0-14 years	HIV Incidence	0.05	1	0.29
Eritrea	African	Low income	ERI	2013	0-14 years	HIV Incidence	0.05	1	0.29
Eritrea	African	Low income	ERI	2014	0-14 years	HIV Incidence	0.04	1	0.29
Eritrea	African	Low income	ERI	2015	0-14 years	HIV Incidence	0.03	1	0.29
Eritrea	African	Low income	ERI	2016	0-14 years	HIV Incidence	0.04	1	0.29
Eritrea	African	Low income	ERI	2017	0-14 years	HIV Incidence	0.03	1	0.29
Eritrea	African	Low income	ERI	2018	0-14 years	HIV Incidence	0.02	1	0.29
Eritrea	African	Low income	ERI	2019	0-14 years	HIV Incidence	0.03	1	0.29
Eritrea	African	Low income	ERI	2020	0-14 years	HIV Incidence	0.02	1	0.29
Eritrea	African	Low income	ERI	2021	0-14 years	HIV Incidence	0.02	1	0.29
Eritrea	African	Low income	ERI	2022	0-14 years	HIV Incidence	0.02	1	0.29

[SamWiseOwl]

It must be you are choosing a filter that removed Congo as the base data show it straight away.

Can you hover over the funnel icon in the top right of your visual and take a screen shot.

That will show what filters are being applied.

[Sal_Brown51]

[SamWiseOwl]

Are you joining to any other tables?

By default Power BI does a Left Outer Join, this will show all the rows from one side of the relationship and matching from the other.

Have a look a the column you are joining on, does Congo have a value in both tables?

You can change this relationship type by performing a Merge in the Query editor.

Change the join type to Full Outer join.

I'd also check if you click on the dropdown by Country in your visual and choose show items with no data, does it appear?

Working fine in my version 😕

[Sal_Brown51]

Yes I'm joining to other tables but I think that might be where the issue is. So the MASTER was the original dataset and the Country has the country codes that matched with the MASTER country codes to bring over the country names. The Unpivot was a way of splitting out the metrics and age groupings as they were all mixed up. Then I created a Countries with Data table as a merge with the unpivot. The Countries with Data table has everything in it, so is the primary table. I've probably done something wrong in the process as I was just using Chat GPT to help me "Chat GPT told me to do it!" 😆

 

[SamWiseOwl]

@Sal_Brown51  if you no longer need the Master and Unpivot in the front end you can disable them. In the query editor right click the query and untick Enable load.

They will still be used in the Joins and pivots etc but wont be brought through into the front end.

This could solve your issue!

[Sal_Brown51]

Thank you, I've done that. It's not changed anything but I now have a warning message on my map visual that I don't know what it means? I'll try and the different names again to see if it works... No idea what I've done! 🙄

[SamWiseOwl]

It means the colour for the filled map no longer matches.

For example if I am using a Theme each colour has an Index e.g Colour 1 = Red #FF0000 and that no longer matches.

Why disabling the load of a table would change that I don't know!

Remove the legend for a moment and change the filled colour to something else.

Ok next thing I would try is disabling the relationship between the two remaining tables.

You can always turn this back on later but it will tell us if its the relationship causing the issue!

[Sal_Brown51]

Ok, I disabled the relationships between the Countries with Data table and the Country table and when I went to the relationships page the Country table was still there. I clicked on it and got an error message. The Manage Relationsips tab is also greyed out? 

[SamWiseOwl]

The relationship will still appear it will change from a solid line to a dotted line.

Feel free to delete the line and recreate it later.

What we want to check is if Congo appears when you are using either tables Country column independent of the other.

[Sal_Brown51]

[SamWiseOwl]

What happens if you try the country code instead?

[Sal_Brown51]

I get the same result. 

[SamWiseOwl]

I am utterly bamboozled. 

If you have the data and now other filters or joins on this there is no reason it shouldn't show you!

[Sal_Brown51]

I think I'll have to just start again.... Thank you for your help though!