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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Line chart combined with table visual

I have a requirement to show line chart with dates and values combined with single row of a table that contains the same values from line chart when hovered upon. That means I just to need show the currently hovered upon values in the table from the line chart. I couldn't find any tailored visual like this. Is there a way we can combine both these visual but only on mouse hover?

 

Thanks

2 REPLIES 2
Ritaf1983
Super User
Super User

You can use the sparklines, if I understand you correctly.
Here is a link to toturial:
https://www.youtube.com/watch?v=OXtxwpRYEkU

Its disadvantage is that the number of each point cannot be seen as a floating window at the point level.
Currently, there is no dynamic solution to this problem.
This type of graph is also available on the Marketplace for a fee.
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200002816?tab=overview&exp=ubp8

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Anonymous
Not applicable

Thanks but my question is slightly different. What I want to show is the last value of a measure(named as Current in the picture below) in a separate table visual's single row, which is being calculated on a certain date and this action is to be performed only when I move my mouse over that date in the line chart. Hope it makes sense.

 

Something like this...

nitin_bhatnagar_0-1682405579569.png

 

Note that I only need to show the LAST value of CURRENT, which is a calculated measure on a particular date.

Another question: I am trying to use the last value of CURRENT using LASTNONBLANKVALUE, but I am not getting correct results also, since it is a measure and yields different results on different dates. Any idea on this one too?

 

Thanks. 

 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors