Map with all clients that had no visit in the last year

[Anonymous]

Good day 🙂

my client asked me for a map, where he can see all clients that havent been visited in the last year.

I have two Tables, one with all his adressdata and one with the visits he has done.
But I have at the moment no real idea how to do that. So if any of you has a tip for me, it would be much appreciated 🙂

[Anonymous · Accepted solution]

Ok it seems I was just very stupid yesterday. So today I fixed it by sending the correct data to PowerBI > only the Adresses who haven't been visited and of cause that works ><

[AC_DATA]

First, make sure the two tables have an active relationship.

From there you can write a calculation to indicate blanks or non-visited locations and place that on the visual or you can just filter to only include locations with blanks on the visits table.

I would be happy to elaborate if you provide more detail.

[Anonymous]

I will try my best.
Basicly I have two tables that are relevant for this (sorry if the translations are bad):

Visits

Clientnumber	Date	Sales person
12345	04.08.2019	10
12346	02.08.2019	23

Adresses

Clientnumber	Clientname	Adress
12345	Client 1	Street, Land
12346	Client 2	Street, Land

They are connected via the clientnumber, and I activated the bidirecational cross-filtering.
The Adresses Table is also connected with different other tables, that are not relevant for this visualisation.

 I made a Bubblemap with the Adresses and tried to use the Date column as a filter, which doesnt seem to work, I still see all adresses on the map, not only those who have been visited in the filtered timeframe.

And then of cause my next step should be to show all the adresses which havent been visited in the filtered timeframe.

For example I want to see which Adresses dont have data in the Visits Table for the last year. The Tables are Views on SQL Tables so if needed I can only give the Visits for the chosen Timeframe to PowerBi.

[Anonymous]

Ok I found my Error, so now I see at least which client HAVE been visited in the last year 🙂