Forum Discussion

ralbouts's avatar
ralbouts
New Member
10 years ago
Solved

Data / visualisation disapearing on map

I've been trying to get a account manager overview across zipcodes in the Netherlands both in power BI desktop and powerbi.com. The dataset is about 3000 records and looks like this:       Whe...
Need Help
  • HarrisMalik's avatar
    HarrisMalik
    10 years ago

     

    ralbouts From your screen shot I assume the issue is related to the warning "Too many values. Not showing all data".

    There is another thread about this issue which you can read here

ralbouts's avatar
ralbouts
New Member
10 years ago

No, the warning in the screenshots is that I need more location data because i'm using zipcodes not "real" location data.

 

But I suppose there could be more then one warnings hiding behind this one. Ill give your link a read :)

HarrisMalik's avatar
HarrisMalik
Icon for Continued Contributor rankContinued Contributor
10 years ago

ralbouts Which columns you are using in the chart. Is it only zip codes or Country + ZipCodes? Using only zipcodes can confuse Power BI because in Netherlands four digit code is used. The same format is used in other countries as well so You need to tell power BI more about which postal Codes you are trying to plot.

 

Secondly in your model did you label Country and ZipCode columns as Country/Region and Postal Code under

Modelling -> Data Category