Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
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.
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 32 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |