Hello, in Azure maps tried to fill the map using the Country name (from Dim_country table) and noticed that if I hover over Italy, it shows me that there is the Vatican. In my case, the Vatican has no values in the Transaction table and Italy has a few but still shows Italy as the Vatican and fills with white colour (because no value in the Vatican):
But if I add bubbles, then the bubble with Italy number appears, but still the whole Italy (except that small bubble) shown as Vatican number and colour:
The workaround for this is just to filter out the Vatican, then you would see Italy filled with it own colour:
Ps. For San Marin everything looks fine, even though it is small country as well.