Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 c...
Need Help
Ritaf1983's avatar
Ritaf1983
Super User
3 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...

 

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.