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

Need Help

2 Replies

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