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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
lucaswhitaker
Employee
Employee

Adding an overlay with a hyperlink to a line chart

I work on a data engineering team, and we have a PowerBI report that includes a line chart showing how long it takes for data to be processed. Spikes in this graph are typically related to an incident (configured in our incident management platform) that captures outages and disruptions to our service. I would like to display those incidents over this line chart (shown as red dots on the graph below). Each dot would represent an incident or group of incidents that fired at a particular time stamp. When I hover over or click on a red dot, I would like to see a tooltip or dialogue panel with more information about the incident(s) including incident number and a hyperlink to the particular incident on our incident management platform. Assuming the underlying data model is working and we are able to correlate incidents pulled from our incident management platform with the data from the line chart, what kind of visuals could I use to create these dynamic overlaid lables with hyperlinks? If there are no existing visuals that would allow this, has anyone tried any plug-ins or custom solutions that they could share?

 

I would appreciate any help 🙂 

 

lucaswhitaker_0-1690311252465.png

 

 

cc: @jayendrans 

1 REPLY 1
dm-p
Super User
Super User

Hi @lucaswhitaker,

 

I believe that tables, matrixes, text boxes and shapes are the only visuals that have hyperlink functionality available, and you cannot currently have hyperlinks directly against a data point. Whilst you could add a report page tooltip that contains a contextual field that could work as a hyperlink, these are non-interactive.

 

In terms of custom solutions, whilst a bit more work than using core visuals Deneb is a certified custom visual that allows you to create bespoke visuals using the Vega and Vega-Lite languages (and is a lot less effort than building a full custom visual). As these languages both have an href property for marks, you can bind a URL to a data point or related mark and this can be delegated to Power BI to open on the user's behalf when clicked. Not sure if that helps, but might give you a couple more ideas.

 

Regards,

 

Daniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors