The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.