Best way to plot bubbles in a map view if the coordinates cannot be calculated

[WorkHard]

Say I have a report where I'm displaying the locations for every event occurring this week in a map view. Each event has a bubble with the location stored as lat, long coordinates.

The coordinates are calculated in a separate application and loaded in BI. Sometimes that application cannot compute the proper coordinates and the lat, long coordinates are blank.

What's the best way to display these events. At the moment Power BI doesn't plot anything without coordinates.

1. Create a random location if the location is blank (in DAX).

2. Create a Card/table and count the number of events without coordinates. This way at least the user is aware something is missing.

Another method that I'm not seeing? 

Thank you!

[TomMartens · Accepted solution]

Hey @WorkHard ,

I would not use something that calculates "some" kind of coordinates.

I'm wondering how you will use DAX or Power Query to calculate coordinates if upstream systems are not able to calculate coordinates. To me, this sounds like also parameters are missing.

For this reason, I would count/flag the rows if coordinates are missing.

But of course, this depends how accurate coordinates have to.

Regards,

Tom

[WorkHard]

Thanks.

Correct, parameters for location (city, zip code) are missing or are entered with a typo by the user in the upstream system.
I was thinking I could plot all the missing locations on the north pole or the headquarters but that sounds worse than not plotting them at all.

Thanks, I'll go with a simple flag that counts the empty coordinate events for now until the upstream system is fixed.