Overlay a point in time on a populated line graph

[Simon_Evans]

Hi all

I have been set an interesting challenge.

I have a company (called trusts in the UK) that owns and oversee's multiple education establishments (called Academies).

At the end of a Academy year the school gets a P8 score. The Trust wants to view all their academies P8 scores from the last 5 years. 

That's fine and I can produce a line graph to show this... however what they also want to on the same graph is the date when each Academy was taken over by the trust.

I have been looking at this for a while now and cannot find anyway to display this data on a line graph so is this possible for a line graph or will another visual be able to do this.

Below are the 2 tables that hold the data.

This one holds the date each academy joined the trust:

This one is the table that holds each Academies P8 scores for the last 5 years starting from 2019. (Covid prevented 2020 and 2021 scores)

The tables have a one to many relationship using the URN. I also have a date table which both the above tables have relationships with

This is currently my line graph which shows the plot of the scores. I just need to be able to put some indicator on each academy showing when they joined.

Any help would be very much gratefully received.

Kindest regards

Simon

[Anonymous · Accepted solution]

Hi @Simon_Evans,

Perhaps you can create a custom report tooltip page include the detail information of records, academy and join data based on the current data point.

Create report tooltip pages in Power BI - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng