Pin maps may remain visible on dashboards even when 'Hide this card if there are no results' is set and there is no data to display

[zbodi74]

Describe the bug

Pin maps do not display records if the coordinates are incomplete. However, a card on a dashboard can only be hidden if the underlying question returns an empty result set.

This opens an edge case - when results exist but the coordinates are incomplete, and the card remains visible.
We should consider displaying a warning in this case to clarify why the card does not disappear, as users might expect it to if there are perceived to be no results.

To Reproduce

1. Create a data set with coordinates where each record has an incomplete coordinate (one of the values or both are null)
2. Display it on a pin map, save it, and add it to a dashboard
3. Set 'Hide this card if there are no results' for this card on the dashboard
   4.(!) The card remains to be visible, in a blank state, showing 'No results!'.

Expected behavior

The current behavior is confusing.
We should consider displaying a message on a blank card that reads, 'No displayable records. N records are hidden due to incomplete coordinates.' This would clarify why results are not being shown, despite their presence.

A possible workaround is to filter out records with empty coordinates from the dataset. However, it might be more beneficial to display a warning to keep the user informed about the presence of such records, which could be valuable information that would otherwise remain unknown.

Logs

No response

Information about your Metabase installation

1.49.8

Severity

P3

Additional context

No response