Forum Discussion
Tooltips are not showing on Line Chart
I have a line chart visual in my report with 5 data fields under the Tooltips well. When I filter my report to last day or two (which is the most relevant time period for this dataset), my tooltips often disappear.
My data is set to Direct Query from a SQL Server. The X axis is a DateTime column from the queried table, and the Y axis is a measure calculating a running total of water consumption.
Tooltips:
Tooltips
Filtered to last 2 days:
Filtered to last two days
Filtered to last 4 days:
Filtered to last 4 days
It is odd. Are you filtering the relative data of a Date Calendar Table? if you don't have a calendar table I'm not sure that the filter will work well. Unless you still have the auto-datetime time intelligence option of power bi.
Check the data. This is not a tooltip issue. I have mentioned the tooltip problems. If you have data in four last days and you don't in two last days it can be that you actually don't have in the last 2 days but the third one has. You should try to have your data always refreshed if you work with relative.
Regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Hi Anonymous ,
When I don't see tooltips, it is generally because of the lack of data.
Are you sure that the fields you added to tooltips are not null for the last two days?
Your second line chart image shows the last four days line, but tooltips are there for the 29th of January.
Could you please check the 31st of January tooltips while you were filtering the last four days of data? (the second line chart image; move your cursor to the right on 31st)
Thanks,
GuvenAgas ,
I do have tooltips for the 31st when filtering for the last 4 days. See Screenshot below.
You may be on to something though--when I look at the data for the chart in focus mode filtered for last two days there is nothing under the tooltip fields, when I do the same thing filtered to last 4 days the table has a value in every cell...
Chart data filtered to last two days (empty)
Chart data filtered to last four days (filled)
- ibarrau
Super User
Hi! It is like you are showing right there. There are two reason when you can't see your value in tooltip. The first one is that you have too much values and the can't fit in the box. The second one is that for that context you have a blank for the value.
It seems that you have the second reason.
Regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
