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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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