Forum Discussion
Filled Map
Ok. Got it. So, it's the 'Map' icon you're talking about ! I've tried your suggestion re switching to a 'Map' visualization and then back again to fix the issue, including putting another Filled Map on the page and then clicking "Country" (in my file), but it has not worked for me - it has not given me a map of the world of filled countries.
At the end of the day, I can't see why I just can't click on the Filled Map icon and then check the box next to Country, (which places it in the location well) and get a map of the world displaying the filled Countiries that are in the Country field in my file. I even changed the Data Category from 'Uncategorised' to 'Country/Region' and that didn't work either !
Surely Bing is capable of recognising basic country abbreviations such as USA, HK, AUS, GER, HOL for example, even if the data category is left as uncategorised.
Here's what I get with your example...
I converted the maps to regular so you can see Hong Kong on the screenshots but you get the exact same result with filled maps
(except you won't see HK unless you zoom in on the filled maps - no matter how big a value you give HK)
First using Country_Name which lists the full country name you get
Using Country which is only abbreviations you get this
AUS which I assumed to be Austria PBI assumes is Australia and GER and HOL which you see in the legend are not recognzied
Hope this helps!
So, if you switch back to Filled Map visualization, does it work?
Here is the FILLED MAP using Country_Name...
To see Hong Kong you have to zoom in - but as you can see it is shaded
Here is FILLED MAP with the abbreviations...
HK shows up but again you have to zoom in
GER and HOL - DO NOT SHOW
EDIT: It seems Bing can work with abbreviations but you have to know the right ones!
Hi Sean
Well, I thought this issue was solved by uninstalling and then reinstalling Power BI on my PC last night. Unbelievably, when I went back into Power BI desktop tonight, the same issue with the filled map (and map) icons not working properly for me appeared again. Filled maps that I even saved last night when it was working had also diappeared when I re-opened the .pbix file containing them tonight. This time, I caught the problem on a screen capture below. This is the screen capture I was going to send you on Monday.
I've clicked on the filled map icon first, then checked the Country Name box and I do not get a filled map - just an empty box with Country Name in it. Yet, when I followed the exact same steps last night after uninstalling and reinstalling Power BI Desktop x64, I got a filled map and it worked just fine !
The data file I'm using (below) in this example is a recreation of the file you came up with last night in the example you sent me:
So, I'm back to square one ! Obviosuly, I can't keep uninstalling and re-installing Power BI Desktop every night - that would be ridiculous !!! This issue is driving me nuts !! Something is either not right, or I'm missing something. Sorry to bother you again, but now you can actually see what's happening when I click on the Filled Map icon, then the Country Name field, hopefully you may be able to tell me what's going on here. As such any further thoughts or ideas you may have would be greatly appreciated.
Kind Regards
Paul
No it doesn't.
Hi
I think I've now got this sorted. Please refer to my post a few minutes ago to Sean. Thanks for getting back to me and for your suggestions - much appreciated.
Regards
Paul
Hi Sean
Thanks for the effort you've put into your replies - a great help and much appreciated. I think I have finally figured it out. I have two PC's here, both running Power BI Desktop x64 (one is a backup PC). So, I decied to click the filled map icon and then check the Country field in Power BI Desktop on the backup PC and it worked just fine - up comes the filled map, just as I thought it should and just like the examples you gave.
Next, I clicked the filled map icon and checked the Country field in Power BI Desktop on my other PC and it doesn't work ! So, I'm thinking there may be something wrong with the install of Power BI Desktop x64 on this PC - it did an update the other night and maybe it didn't install or update some of the components correctly. So, I uninstalled it, downloaded and installed the latest version, clicked on the filled map icon, checked the Country field and guess what - up comes the filled map, just like on my backup PC.
I can only assume therefore, that the problem all along has probably been something to do with a component of Power BI Desktop that Maps relies on not either being corrupt or being installed correctly on my main PC.
Thanks again for you examples and advice - a great help !
Kind Regards
Paul
PS: FYI - AUS is Australia and AUT is Austria !
