Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
Not sure if anyone can help I have a customer list I have imported from an excel spreadsheet into a map in Desktop Power BI.
All the customers have appeared except those in EIRE (Southern Ireland) and New Zealand.
I have set the location to postcode as 99% of the customers are in the UK however I can't get these remaining small number to appear.
Is there a way of including them??
Thanks
Hi @Qualube,
Which map do you use in Power BI?
I have made a test with ArcGIS Maps for Power BI, which works as expected.
Please have a try with ArcGIS Maps for Power BI.
If you still need help, could you share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
Hi Cherry
Thanks so much for your reply I am using the standard map visualisation but using the postcode as the location value so the customers that are outside the UK which don't have postcodes aren't displayed.
The same happens with the ArcGIS map, I know why it's happening but not sure how to solve it.
Mick
Hi @Qualube,
Have you solved your problem?
If you have solved, could you please share the solution or accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry
Hi Cherry
Not yet still looking for a solution, I can use Country then filter down but still can't get them all to show.
Thought I might try a seperate table to link the non postcode customers and try to set up an IF statement somewhere.
If I figure it out I will post the solution.
Thanks
Hi @Qualube,
but using the postcode as the location value so the customers that are outside the UK which don't have postcodes aren't displayed.
If I understand your scenario correctly, you want to show the customers outside the UK which don't have postcodes?
If you don't have post codes, you can’t locate it on the map.
As a workaround, you could set the default postcodes for the customer outside the UK which don't have postcodes, then it will show the default location on the map.
Best Regards,
Cherry
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |