Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Simon_Evans
Helper I
Helper I

Overlay a point in time on a populated line graph

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:

Simon_Evans_0-1660053463594.png

 

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)

Simon_Evans_1-1660053533112.png

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

Simon_Evans_2-1660053641500.png

 

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.

Simon_Evans_3-1660053708795.png

Any help would be very much gratefully received.

Kindest regards

Simon

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.